参考地址:https://www.cnblogs.com/fengxiaojiu/p/7994124.html
1、offset fetch next 方式:
select number_show,id from technology_board_access_storage_log t
order by t.create_date,id
offset (2-1)*5 rows fetch next 5 rows only
--offset (第几页-1)*每页条数 rows fetch next 每页条数 rows only
2、row_number 方式:
select number_show,id from (
select *, ROW_NUMBER() OVER(order by t.create_date,id ) AS rowNumber from technology_board_access_storage_log t
) as b
where rowNumber between (2-1)*5+1 and 2*5
--where rowNumber between (第几页-1)*每页条数+1 and 第几页*每页条数
3、top 方式:
select top 5 number_show,id from technology_board_access_storage_log t
where id not in (select top ((2-1)*5) id from technology_board_access_storage_log t order by t.create_date,id)
order by t.create_date,id
--select top 每页条数 number_show,id from technology_board_access_storage_log t
--where id not in (select top ((第几页-1)*每页条数) id from technology_board_access_storage_log t order by t.create_date,id)
--order by t.create_date,id