select * from
(select ROW_NUMBER() over (order by 排序字段) desc) row , *from 表名
where 1=1
and 筛选条件) 别名
where row between 每页显示的条数* (当前页码 - 1) + 1 and 每页显示的条数*当前页码
select * from
(select ROW_NUMBER() over (order by 排序字段) desc) row , *where row between 每页显示的条数* (当前页码 - 1) + 1 and 每页显示的条数*当前页码