Orcal中的分页

第一种：显示从5 到 10 的员工
1、table01 按照工资降序排列出所有员工
select * from emp order by sal desc

2、table02 在员工表table01中设定rownum，rownum<=5
select rownum no, e.*
from (select * from emp order by sal desc) e
where rownum <= 5

3、在table02中限定条件rownum>3
select *
from (select rownum no, e.*
from (select * from emp order by sal desc) e
where rownum <= 10) where no>5

第二种：显示从5 到 10 的员工
select * from
(select rownum no, e.* from (select * from emp order by sal desc) e)
where no >= 5 and no <= 10

北京小辉微信公众号

大数据资料分享请关注