How to find out the top 5 earners of company based on emp dept table?

Oracle Apps Interview Questions › Category: SQL › How to find out the top 5 earners of company based on emp dept table?
0 Vote Up Vote Down
Questions Master asked 10 years ago

How to find out the top 5 earners of company based on emp dept table?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

SELECT DISTINCT ename,sal
from emp e
WHERE 4>=
  (SELECT COUNT(DISTINCT sal) FROM emp a WHERE a.sal>=e.sal
  )
ORDER BY sal DESC;