Select sal from (select sal, dense_rank() over( order by sal desc) r from students) where r=&n N = Place the position of any highest salary eg:- 2nd highest n=2, 3rd highest n=3 and so on.

select max(salary) from emp where salary<(select max(salary)from emp);

Select max(salary) from emp where salary not in (select max(salary)from emp);