select id,mc,agefrom table1 xwhere age in(select min(age)from table1 ywhere x.mc=y.mcgroup by mc ) 差不多就是这个了