Cacher is the code snippet organizer for pro developers

-- Get top n records for each group of grouped results

select * 
from (select * from mytable order by `Group`, Age desc, Person) x
group by `Group`

-- http://stackoverflow.com/questions/12113699/get-top-n-records-for-each-group-of-grouped-results
-- http://www.w3schools.com/sql/sql_func_first.asp