Find 2nd Highest Salary And Nth Salary In Sql

select name, MAX(salary) as salary from Employee where salary < (select MAX(salary) from employee);


<!-- Nth row query  -->

SELECT * FROM (
  SELECT e.*, 
  ROW_NUMBER() OVER (ORDER BY salary DESC) as rn 
  FROM Employee e
)
WHERE rn = N;