Find nth highest salary in SQL

To Get 2^nd highest salary

select * from (

  select e.*, row_number() over (order by sal desc) rn from emp e

)

where rn = 2

To Get 3^nd highest salary

select * from (

  select e.*, row_number() over (order by sal desc) rn from emp e

)

where rn = 3