-- MySql: First result only returned, so Person with max age in each Group select * from (select * from mytable order by `Group`, age desc, Person) x group by `Group`;