Query to find top 3rd salary in an organisation using RANK function

select empname, salary
from (select empname,salary ,rank() over(order by salary desc) sal_rank from EMPLOYEE)
where sal_rank=3

(From Oracle 9i onwards)