nth highest salary

1#Method 1
2SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1
3
4#Method 2
5SELECT salary FROM Employee AS e1 
6WHERE n-1=(SELECT COUNT(DISTINCT,salary) FROM Employee AS e2 
7           WHERE e2.salary>e1.salary)

1SELECT MIN(EmpSalary) from ( 
2	SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 3 
3);

1SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1