半缘修道半缘君
【作业】列出薪资第2高到第8高的员工
上一篇 /
下一篇 2014-03-19 12:55:53
/ 个人分类:不懂的请指教~
SELECT sal,ename
FROM ( SELECT ROWNUM r,o.*
FROM (
SELECT *
FROM emp
ORDER BY sal DESC
) o
WHERE ROWNUM < = 8
)
WHERE r > = 2;
或
SELECT sal,ename
FROM ( SELECT *
FROM emp
ORDER BY sal DESC
)
WHERE ROWNUM <=8
MINUS
SELECT sal,ename
FROM ( SELECT *
FROM emp
ORDER BY sal DESC
)
WHERE ROWNUM <2
ORDER BY sal DESC;
或
SELECT *
FROM (
SELECT rank() over(ORDER BY sal DESC)AS rank,ename,job,sal
FROM emp
)
WHERE rank > = 2
AND rank < = 8;
但是查询的结果只有7个 工资第二高的员工有两个 实际上应该还有一个工资为1300的员工没有查询到
收藏
举报
TAG: