SELECT SALARY
FROM
(SELECT DISTINCT SALARY FROM EMP ORDER BY SALARY DESC)
WHERE ROWNUM <=5;
FROM
(SELECT DISTINCT SALARY FROM EMP ORDER BY SALARY DESC)
WHERE ROWNUM <=5;
Showing posts with label How to find Third or Nth Maximum salary from salary table?. Show all posts
Showing posts with label How to find Third or Nth Maximum salary from salary table?. Show all posts
Wednesday, 30 October 2013
Subscribe to:
Comments (Atom)