MySQL用GROUP BY分组取最新一条数据

SELECT
t.*
FROM
task_examine t
JOIN (
SELECT
SUBSTRING_INDEX( group_concat( id ORDER BY crt_time DESC ), ‘,’, 1 ) AS id
FROM
task_examine
GROUP BY task_id ) tmp
ON t.id = tmp.id ORDER BY crt_time desc;