select * from (
select *,row_number()
over(order by zkzh desc)n from tb
)hhh
where hhh.n>50000 and hhh.n<=50010
百万级数据翻页查询优化
最新推荐文章于 2023-02-03 17:31:34 发布
select * from (
select *,row_number()
over(order by zkzh desc)n from tb
)hhh
where hhh.n>50000 and hhh.n<=50010