SQLSERVER中三种分页

三种分页方式 关键字:NOT IN , MAX(ID) , ROW_NUMBER()

select top 10 * 
from Users 
where UserID not in 
(select top (2*10) userid from users)

 

select top 10 * from users where userid>
(
    select  isnull(max(userid),0) 
    from 
    (
        select top (10*2) userid 
        from users 
        order by userid 
    ) a
)
order by userid

 

select * from (
select  ROW_NUMBER() over(order by LogID) orderid,* from OrderLog (nolock)
) a
where a.orderid> 200 and a.orderid< 301