SQL2005 高效分页

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