分页获取数据的方法

select * from（select * , row_number() over      (         order by         time    )  as rownumfrom history）AAA where  AAA.rownum>50000 and AAA.rownumber<50010

一般情况下，我们用这种方式封装公用分页方法。

 

大数据时，下面方法效率高些：

select hhh.n , hh.* from history hh ,(     select top 50010 row_number() over      (         order by          time desc     ) n,id     from history  ) hhh where hhh.id = hh.id and hhh.n > 50000 order by  hhh.n desc