Question

How to find top three highest salary in emp table in oracle?

Answer 1

Use this:

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

I hope this helps you.