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