本文实例汇总了Oracle实现分页查询的sql语法,整理给大家供大家参考之用,详情如下:
1.无ORDER BY排序的写法。(效率最高)
经过测试,此方法成本最低,只嵌套一层,速度最快!即使查询的数据量再大,也几乎不受影响,速度依然!
sql语句如下:
sql;">
SELECT *
FROM (Select ROWNUM AS ROWNO,T.*
from k_task T
where Flight_date between to_date('20060501','yyyymmdd') and
to_date('20060731','yyyymmdd')
AND ROWNUM <= 20) TABLE_ALIAS
WHERE TABLE_ALIAS.ROWNO >= 10;
2.有ORDER BY排序的写法。(效率最高)
经过测试,此方法随着查询范围的扩大,速度也会越来越慢!
sql语句如下:
sql;">
SELECT *
FROM (SELECT TT.*,ROWNUM AS ROWNO
FROM (Select t.*
from k_task T
where flight_date between to_date('20060501','yyyymmdd') and
to_date('20060531','yyyymmdd')