Friday, January 7, 2011

SQL Query, to get the Second Highest Salary

SELECT MAX(Salary) FROM dbo.Employee WHERE Salary <> (SELECT MAX(Salary) FROM Employee)

No comments:

Post a Comment