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