SQL query to find the nth highest salary

• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to select the nth highest salary

select * from ( select empid,empname,salary ,dense_rank() over (order by salary desc) R  employee) where R = &n;