SQL2005高效分页sql语句

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