mysql 先排序再分组取时间最近的数据

mysql 先排序分组后取时间最近的数据

先直接上sql，解释后续有时间再写

SELECT * FROM 
(
 SELECT v.* FROM people v
 INNER JOIN (SELECT  MAX(add_time) 'max_add_time' FROM people 
 GROUP BY name , age , sex ) c ON v.add_time = c.max_add_time
 WHERE v.`status` IN ( '1' , '2' , '3' , '4' ) ) AS temp GROUP BY name , age , sex ORDER BY add_time DESC
 LIMIT 0,10;

需要的自己先切换表明和字段名使用