mysql按字段分组并获取每个分组按照某个字段排序的前三条

a.* from data a where 3 > (select count(*) from data where brand_id = a.brand_id and total_num > a.total_num ) order by a.brand_id, a.total_num desc;