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
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