方法1:

 SELECT * 
 FROM
 	(
	SELECT * from test11  
	ORDER BY in_date DESC LIMIT 3
    ) a 
 GROUP BY type

方法2:

SELECT * 
FROM
	(
	SELECT DISTINCT * 
	from test11  
	ORDER BY in_date DESC
    ) a 
GROUP BY type

原文链接：Mysql分组查询获取每组最新一条数据

Q.E.D.