rownum
rownum <= num
from (select rownum r, empno, ename from emp) t
where r > 10
from (select ename, sal from emp order by sal desc)
where rownum <= 5
(
select rownum r, ename, sal
from (select ename, sal from emp order by sal desc) t1
) t2
where r >=6 and r <= 10
1, 概念
对结果集进行排序, 隐藏的字段, 从1开始.2, 格式
rownum < numrownum <= num
3, 注意
①不能使用 rownum > num②先对结果集每条记录进行编号, 然后再order by排序
4, 求 结果集中 第十条后的数据
select empno, enamefrom (select rownum r, empno, ename from emp) t
where r > 10
5, 求薪水最高的五个人的名字
select ename, salfrom (select ename, sal from emp order by sal desc)
where rownum <= 5
6, 求薪水最高的第6到第10名雇员
select r, ename, sal from(
select rownum r, ename, sal
from (select ename, sal from emp order by sal desc) t1
) t2
where r >=6 and r <= 10