SQL Server 2005高效分页SQL语句

SQL2005 高效分页sql语句，需要的朋友可以参考下。

1、代码如下:
select top 10 * from
( select top (@Page * 10) ROW_NUMBER() OVER (order by id) as RowNum, id, username
from Guest where username = 'user'
) as T
where RowNum > ((@Page - 1) * 10)

2、代码如下:
select * from
( select ROW_NUMBER() OVER(order by id) as RowNum,id,username
from Guest where username = 'user'
) as T
where RowNum between 31 and 60

3、代码如下:
with T as
(select ROW_NUMBER() OVER(order by id) as RowNum,,id,username
from Guest where username = 'user'
)
select * from T
where RowNum between 31 and 60

本文标题：SQL Server 2005高效分页SQL语句
本文地址：http://www.q0738.com/mssql/1382.html

• SQL Server 2005创建远程登录帐户的SQL语句
• SQL Server 2005日志清理，清除日志的方法
• MSSQL Server 2005字符串连接方法 避免无效的连接错误
• SQL Server 2005简单的全文检索
• SQL Server CROSS APPLY和OUTER APPLY的应用详解
• SQL Server分布式事务问题