Register now or log in to join your professional community.
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