本文介绍了一种使用嵌套子查询的方式来进行SQL分页查询的方法，这种方法通过限制外层查询的范围来提高查询效率。具体实现是先通过子查询获取到限定范围内的记录编号，再利用这些记录编号进行数据检索。
select *
from (select rid
from (select rownum rn, rid
from (select rowid rid from lg_order o order by o.order_id)
where rownum <= 20)
where rn >= 10) t1,
lg_order t2
where t2.rowid = t1.rid
from (select rid
from (select rownum rn, rid
from (select rowid rid from lg_order o order by o.order_id)
where rownum <= 20)
where rn >= 10) t1,
lg_order t2
where t2.rowid = t1.rid
扫一扫
873
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
