5th highest salary sql server query code example

Example 1: n highest salary in sql

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

Example 2: 3rd height salary sql

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