【转载】mysql去重获取最新日期的一组数据

SELECT 
4 	t1.* 
5 FROM t_login_log t1
6 	LEFT JOIN t_login_log t2 ON t1.user_id = t2.user_id AND t1.login_time < t2.login_time 
7 WHERE t2.id IS NULL;