方法一 select * from messages where id in ( select max(id) fom messages group by name ); -- 优化 select b…