Find out the top 5 earners of company?

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 1842
SQL>SELECT DISTINCT SAL FROM EMP E WHERE 5>=(SELECT COUNT(DISTINCT SAL)
FROM
EMP A WHERE A.SAL>=E.SAL)ORDER BY SAL DESC;

Comments or Responses

Login to post response