MySQL之去重查询最新一条数据

• 这种查询会导致全表扫描

select id,name,create_date from sys_user a

where not exists (select * from sys_user b where a.name = b.name and a.create_date < create_date )  ;

• 优化版

SELECT * FROM hy_driver_on_line_the_way WHERE create_time in(
	SELECT
		MAX( b.create_time )
	FROM
		hy_driver_on_line_the_way AS b
	WHERE
		b.driver_id IN ( 1, 2, 3 )
	GROUP BY
		b.driver_id
)