oracle 分页查询sql

最新推荐文章于 2024-08-19 08:45:16 发布

Yuyuquan

最新推荐文章于 2024-08-19 08:45:16 发布

阅读量285

点赞数 1

分类专栏： oracle

本文链接：https://blog.csdn.net/qq_27918787/article/details/52584534

版权

oracle 专栏收录该内容

33 篇文章 0 订阅

订阅专栏

 分页查询

（假设每页显示10条）

不包含排序：


--效率低

select * from (select rownum rn, d.* from DJDRIVER d  )p where p.rn<=20 and p.rn>=10;

select * from (select rownum rn, d.* from DJDRIVER d  )p where p.rn between 10 and 20;

--效率高 

select * from (select rownum rn, d.* from DJDRIVER d where rownum<=20 )p where p.rn>=10;



包含排序：


--排序+区间查询1（效率低）

select * from (select rownum rn, t.* from ( select d.* from DJDRIVER d order by DJDRIVER_DRIVERTIMES)t )p where p.rn<=20 and p.rn>=10;

select * from (select rownum rn, t.* from ( select d.* from DJDRIVER d order by DJDRIVER_DRIVERTIMES)t )p where p.rn between 10 and 20;

--排序+区间查询2（效率高） 

select * from (select rownum rn, t.* from ( select d.* from DJDRIVER d order by DJDRIVER_DRIVERTIMES)t where rownum<=20 )p where p.rn>=10;