mysql分组后取排序第一条

SELECT a.group_id,a.num,a.intime FROM (SELECT group_id,MAX(intime) AS created_at FROM test GROUP BY group_id) b LEFT JOIN test AS a ON a.intime= b.intime AND a.group_id = b.group_id