mysql查詢(xún)每個(gè)組最大的那條記錄
假如有如下表：
圖示表
解決方案一：
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
