MySQL中查询时间最近的一条记录

问题：MySQL中查询时间最近的一条记录，表数据如下

解决：

方法一：

SELECT
	a.* 
FROM
	( SELECT NAME, max( date ) AS date FROM abc GROUP BY NAME ) AS b
	LEFT JOIN abc AS a ON a.NAME = b.NAME 
	AND a.date = b.date

方法二：

SELECT
	t1.* 
FROM
	abc t1
	LEFT JOIN abc t2 ON t1.NAME = t2.NAME 
	AND t1.date < t2.date 
WHERE
	t2.NAME IS NULL