i want to find out top 5 salaries of employees.
I am working with Oracle 8.0.5. This query seems not to work. Can u give me another solution to this query. I dont want to achieve the result through a cursor.
select sal from ( select distinct sal from emp order by sal desc ) where rownum <= 5;