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

Question

Sravan Aravapalli · Answer

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

Muhammad Arshad Gondal · Answer

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

Muhammad Waqar Arif · Answer

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

Atiqul Islam · Answer

SELECT MAX(Salary) FROM Employee
WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee )

Shakir Ali · Answer

Select Top 1 Salary From

(Select Distinct Top 2

Salary from tblEmployee

Order by Salary)

Result

Order by Salary