sqlServer 数据库分页汇总

--分页方式一 例用ROW_NUMBER_OVER 2005 版本以上可用
select * from (select * ,ROW_NUMBER()over(order by id) as rank  from MOCK_DATA) as tab where rank between 50 and 60

--分页方式二 not in 实现分页(通用)
select top 30 *  from MOCK_DATA where id not in(select top 1900 id from MOCK_DATA  order by id) order by id

--分页方式三 offset fetch next 2012 版本以上可用
select * from MOCK_DATA order by id offset 10 rows fetch next 30 rows only

--分页方式四 (通用)
select  * from
(
    select  top 30 * from
    (
        select top 60 *  from MOCK_DATA order by id asc
    ) as tab order by id  desc
) as tab1 order by id