mysql 按某个字段分组，取每组最新的数据

mysql 按某个字段分组，取每组最新的数据

SELECT t1.*
FROM your_table t1
INNER JOIN (
    SELECT group_column, MAX(date_column) AS max_date
    FROM your_table
    GROUP BY group_column
) t2 ON t1.group_column = t2.group_column AND t1.date_column = t2.max_date;