How to display the names of the employees who earn highest salary in their respective departments?

Oracle Apps Interview Questions › Category: SQL › How to display the names of the employees who earn highest salary in their respective departments?

0 Vote Up Vote Down

Questions Master asked 11 years ago

How to display the names of the employees who earn highest salary in their respective departments?

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 11 years ago

SELECT ename,
sal,
deptno
FROM emp
WHERE sal IN
(SELECT MAX(sal) FROM emp GROUP BY deptno
);