MySQL query for nth highest salary.

Select name,salary from employee
Order by salary desc limit 1 offset 2.

When set offset 1 then return 2nd, set offset 2 then return 3rd highest salary.