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

Add Comment

📖 Read More