select *
from (select A.*, rownum RN
from (需要查询结果的复杂sql 语句) A
where rownum <= 结束记录)
where RN >= 开始记录
oracle分页
最新推荐文章于 2022-03-05 16:34:07 发布
select *
from (select A.*, rownum RN
from (需要查询结果的复杂sql 语句) A
where rownum <= 结束记录)
where RN >= 开始记录