oracle rownum相关

最新推荐文章于 2022-09-23 14:31:14 发布

Yuyuquan

最新推荐文章于 2022-09-23 14:31:14 发布

阅读量216

点赞数

分类专栏： oracle

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

版权

oracle 专栏收录该内容

33 篇文章 0 订阅

订阅专栏

--rownum小于某个数时可以直接作为查询条件（注意oracle不支持select top）
select * from student where rownum <3;

--查询rownum大于某个数值,需要使用子查询，并且rownum需要有别名
select * from(select rownum rn ,id,name from student) where rn>2;
select * from (select rownum rn, student.* from student) where rn >3;

--区间查询
select * from (select rownum rn, student.* from student) where rn >3 and rn<6;

--排序+前n条
select * from (select rownum rn, t.* from ( select d.* from DJDRUVER d order  by drivernumber)t )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<9 and p.rn>6;

--排序+区间查询2
select * from (select rownum rn, t.* from ( select d.* from DJDRIVER d order by DJDRIVER_DRIVERTIMES)t where rownum<9 )p where p.rn>6;--效率远高于方式一