MySql 5.5版写法
select * from (select * from table_name order by create_time desc) as t group by t.id;
MySql 5.7版写法
select * from (select * from table_name order by create_time desc limit 100000) as t group by t.id;
MySql 5.5版写法
select * from (select * from table_name order by create_time desc) as t group by t.id;
MySql 5.7版写法
select * from (select * from table_name order by create_time desc limit 100000) as t group by t.id;