PalTech interview question

write a SQL query to find the Nth highest salary from an Employee table.

Interview Answer

Anonymous

24 Feb 2026

Select * from ( select *,row_number() over(orderby salary desc) as rnk from employees) where rnk=n