SQL2005 高效分页sql语句

265 阅读 0 评论 175 点赞

我是靠谱客的博主自由魔镜，这篇文章主要介绍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 