Write a query to find second highest salary of an employee?

SELECT Name FROM   Employees WHERE  Salary = (SELECT MIN(Salary) FROM   (SELECT DISTINCT TOP (2) Salary FROM   Employees ORDER  BY Salary DESC) T);

SELECT MAX(SALARY) FROM MASTER WHERE SALARY NOT in(SELECT MAX(SALARY) from master)

SELECT TOP 1 Salary FROM ( SELECT TOP 2 Salary FROM Employee ORDER BY Salary DESC) AS Employee ORDER BY Salary ASC;

Select Top 1 Salary From

(Select Distinct Top 2 

Salary from tblEmployee

Order by Salary)

Result

Order by Salary