1、简单分页
select top 每页数据条数 * from 表名 where id not in (select top ((2-1)*5) id from wg_users order by 排序列名 desc) order by 排序列名 desc
2、RowNumber分页
select * from (select ROW_NUMBER() OVER(Order by 排序列名) AS RowNumber,* from 表名) as b
3、Offset and Fetch分页
select * from 表名 order by 排序列名 offset (当前页数-1)*每页数据条数 row fetch next 每页数据条数 row only