select distinct a.NAme,max(a.salary) as salary from table_name a group by NAme order by salary desc
select distinct a.NAme,max(a.salary) as salary from table_name a group by NAme
SELECT MAX(field1), field2 FROM table1 GROUP BY field2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)