SELECT TOP(3) [ID], [Name], MAX([Salary]) FROM YourTable GROUP BY [ID], [Name] ORDER BY [Salary] DESC
select top 3 Name,Salary from Employee order by Salary desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)