分页获取数据的方法

select * from

（

select * , row_number() over  

    ( 

        order by 

        time

    )  as rownum

from 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