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 Ro

XSwsvRvXX

wNum www.cppcns.com> ((@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'
)
selewww.cppcns.comct * from T
where RowNum between 31 and 60