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