Thursday, December 22, 2011

Find 2nd Highest Salary of Employee using Query

SELECT TOP 1 [Salary]
FROM
(
SELECT  DISTINCT TOP 2 [Salary]
FROM [dbo].[Employee]
ORDER BY [Salary] DESC
) temp
ORDER BY [Salary]


Thanks
Alok Kumar Sharma










No comments:

Post a Comment