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 RowNum > ((Page – 1) * 10) 2、 代码如下: select * from ( select ROW_NUMBER() OVER(order by