How to find third maximum salary from salary table?
You can get the 3rd maximum salary as :
SELECT MIN(Emp_Salary) FROM Salary WHERE Emp_Salary IN(SELECT TOP 3 Emp_Salary FROM Salary ORDER BY Emp_Salary DESC)
Advertisements
You can get the 3rd maximum salary as :
SELECT MIN(Emp_Salary) FROM Salary WHERE Emp_Salary IN(SELECT TOP 3 Emp_Salary FROM Salary ORDER BY Emp_Salary DESC)
Advertisements
