Find out the nth-highest salary from table

select * from 
(
    select sal, rank() over (order by sal DESC/ASC) rnk 
    from emp
) 
where rnk = 1/2/3/4/5/6/...;

Learn Oracle with me

Oracle developer

Yasser.hassan@yandex.com