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