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;

Stumble
Delicious
Technorati
Twitter

0 Comments:

Post a Comment