方法一 sql2005 高效分页sql查询语句经典实例
代码如下:
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查询语句经典实例用法了吧，其实代码都很简单哦。