declare @currentPageIndex int
set @currentPageIndex=3
select top 5 * from (select row_number() over(order by getdate() desc) as rownumber,* from test) as temp_table
where rownumber>5*(@currentPageIndex-1)
原文：http://www.cnblogs.com/laopo/p/5090369.html