How to display the Job groups having total salary greater than the maximum salary for managers?

Oracle Apps Interview Questions › Category: SQL › How to display the Job groups having total salary greater than the maximum salary for managers?

0 Vote Up Vote Down

Questions Master asked 10 years ago

How to display the Job groups having total salary greater than the maximum salary for managers?

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 10 years ago

SELECT job,
SUM(sal)
FROM emp
GROUP BY job
HAVING SUM(sal)>
(SELECT MAX(sal) FROM emp WHERE job=’MANAGER’
);