How can you get the 3rd highest salary in SQL from employee database?

select * from ( select eno, ename, sal, rank() over(order by sal desc) rnk ) where rnk = 3