oracle用rownum分页的问题
select * from
(select seq, rownum rm from table_a where biz_date = '2023-02-03' order by id) a
where
a.rm <= pageNum * pageSize
and
a.rm > (pageNum-1) * pageSize
分页sql是这样写的,运行了几个月没有出问题,最近突然出现问题,导致有的数据被查到了好几次,后来改成了标准写法就好了,但是还是没有理解到是什么原因,有没有小伙伴帮忙指明一个方向
修改后写法
select * from
(select
a.*, rownum rm
from
(select req from table_a where biz_date = '2023-02-03' order by id) a
where
rownum <= pageNum * pageSize)
where
rm > (pageNum-1) * pageSize