SQL Server分页查询语句
SQL Server分页查询是我们经常会用到的功能，下面就为你介绍分页查询的相关语句，希望对您学习SQL Server分页查询方面能有所帮助。SQL Server2000：
[*]SELECT TOP @pagesize *
[*]FROM TABLE_NAME
[*]WHERE>
[*](
[*]SELECT TOP @pagesize*(@page-1)>
[*]FROM TABLE_NAME
[*]ORDER BY>
[*])ORDER BY>
SQL Server 2005：
SQL Server分页查询方法一：
[*]SELECT ...
[*]FROM
[*](
[*] SELECT ROW_NUMBER() OVER (ORDER BY>
[*] FROM TABLE_NAME
[*] ) AS T
[*]WHERE T.RowNum> 10 and T.RowNum<= 20
SQL Server分页查询方法二：
[*]WITH DataList AS
[*](
[*] SELECT ROW_NUMBER() OVER (ORDER BY O.ID DESC)AS RowNum, ......
[*] FROM .....
[*] WHERE ......
[*] )
[*]SELECT ......
[*]FROM DataList
[*]WHERE RowNum BETWEEN 10 AND 20
页:
[1]