Find employees have salary greater than maximum salary in 'IT' department
SELECT ENAME, JOB, HIREDATE
FROM EMP
WHERE SAL > (SELECT MAX(SAL)
FROM EMP
WHERE DEPTNO =
(SELECT DEPTNO
FROM DEPT
WHERE DNAME = 'IT'));
Find employees have salary greater than maximum salary in 'IT' department
SELECT ENAME, JOB, HIREDATE
FROM EMP
WHERE SAL > (SELECT MAX(SAL)
FROM EMP
WHERE DEPTNO =
(SELECT DEPTNO
FROM DEPT
WHERE DNAME = 'IT'));
at 5:50 PM
Labels: Oracle, Oracle Query, PL/SQL
No comments:
Post a Comment