mysql 获取每组 创建时间最早的数据

方法1

select * from (select * from 表名 order by create_time desc limit 999)aa  group by 分组字段;

方法2

select * from 表名where id in (
SELECT SUBSTRING_INDEX(GROUP_CONCAT(id order by create_time desc ),',',1) as create_time
FROM 表名 group by 分组字段
);

方法三

select * from  (select  * from 表  having 1 order by create_time ) a  group by id