???????OFFSET FETCH?????
???????LINQ?????????????????SQLServer????????????????????????????????е??????SQL Server Compact 4.0???????OFFSET FETCH???
????SELECT  *
????FROM    dbo.Products
????ORDER   BY UnitPrice DESC
????OFFSET  ( @pageSize * ( @pageIndex - 1 )) ROWS
????FETCH NEXT @pageSize ROWS ONLY;
??????????LINQ????OFFSEET????SKIP??FETCH NEXT????TAKE??
???????????????????SQL Server CE 4.0?????????SQL Server 2012??SQL Server 2014?????????????Microsoft Webmatrix???????????????1????
???????
????????????????????????????????????????дSQL??????????????????????ε?????????г????????????????*????????в?????????????????????????????????????????????????????????????????????????????Ч?????????SQL?е????????????????????????????B???????У?????????????????д?????е????￡?????????????SQL Server ???Щ???????CTE??IN ??Exist???????????ЩС???????????????????????
????????????Щ?????????????????????????????????????á?
????????Top – Not In - Top????????????????????in???Ч???????????????汾??SQL Server??
????????ROW_Number????????????????У?Ч?????LINQ?е?SKIP??TAKE?????????????????з?????????????????????????????
????FFSET FETCH ??????SQL Server CE 4.0 ?в?????????????????SQL Server 2012??????????????comparing-performance-for-different-sql-server-paging-methods??????????????????Sql Server 2012 ???????????(offset and fetch)????????????????
???????????SQLServer?????SQL????????????????????????????