Monday, April 16, 2012

How to find top three highest salary in emp table using sql


The top three highest salary in emp table using sql is

SELECT *FROM ( SELECT *FROM emp ORDER BY Salary desc ) WHERE rownum <= 3;