使用 row

select * from

(select ROW_NUMBER() over (order by 排序字段) desc) row , * from 表名  where 1=1 and 筛选条件)  别名

where row between  每页显示的条数* (当前页码 - 1) + 1  and 每页显示的条数*当前页码