SQL2005 高效分页sql语句
摘要：1、复制代码代码如下:selecttop10*from(selecttop(@Page*10)ROW_NUMBER()OVER(orderb...
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
【SQL2005 高效分页sql语句】相关文章：
★ SQL2005 ROW_NUMER实现分页的两种常用方式
★ 正解SQLSEVER 2005 sql排序(按大小排序)
★ SQLserver 2008将数据导出到Sql脚本文件的方法
★ SQLServer2005 Output子句获取刚插入的ID值
★ SQL Server 2008 R2数据库镜像部署图文教程
★ SQL高级查询
★ 精妙的SQL语句