How to find 2nd or Nth highest salary using SQL query window functions

Find 2nd or Nth highest salary using window functions:

SQL query:

select * from (select *, rank() over(order by salary) as salary_rank from salary) where salary_rank=2
select * from (select *, rank() over(order by salary) as salary_rank from salary) where salary_rank=N

N is to get Nth highest salary in salary table.