查询年薪在3万到4万之间的 员工及下级的工作,年薪
SELECT LPAD(' ',4*(LEVEL-1)) || ENAME ENAME,
LPAD(' ',4*(LEVEL-1)) || JOB JOB,
LPAD(' ',4*(LEVEL-1)) || SAL*12 SAL
FROM EMP
START WITH EMPNO IN
(
SELECT EMPNO
FROM (
SELECT EMPNO,
MAX(SA1) SA2
FROM (
SELECT LEVEL SA1,
EMPNO
FROM EMP A
START WITH SAL*12 BETWEEN 30000 AND 40000
CONNECT BY MGR= PRIOR EMPNO
)
GROUP BY EMPNO
)
WHERE SA2=1
)
CONNECT BY MGR= PRIOR EMPNO;
要点在于查找出顶端节点的EMPNO
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25538895/viewspace-706896/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25538895/viewspace-706896/