bw1023627606的博客

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