RsD0p9BK
1/13/2016 - 6:48 AM

get_top_record.sql

-- 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