mysql查询每个组最大的那条记录

mysql查询每个组最大的那条记录

假如有如下表：

图示表

解决方案一：

SELECT n1.* FROM news n1 LEFT JOIN news n2 
   ON (n1.name = n2.name and n1.id < n2.id)
where n2.id is null;

解决方案二：

select n1.* from 
    news n1 
    inner join 
    (select name, max(id) as maxid from news group by name) as n2 on
n1.id = n2.maxid

查看更多解决方案