SELECT MAX(field1), field2 FROM table1 GROUP BY field2
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)