How to display the nth highest salary from a table in a MySQL query?

MySQL - Interview Questions

Let us take a table named the employee.

To find Nth highest salary is :

select distinct(salary)from employee order by salary desc limit n-1,1

if you want to find 3rd largest salary :

select distinct(salary)from employee order by salary desc limit 2,1