MySQL 获取时间最大的查询记录

MySQL 获取时间最大的查询记录

解决方案

MySQL 根据账号汇总创建时间最大的的记录：

SELECT
ws.*
FROM
account_state ws
INNER JOIN (
	SELECT
	account_id,
	MAX(create_time) AS max_create_time
	FROM
	account_state
	GROUP BY
	account_id
) max_ws ON ws.account_id = max_ws.account_id AND ws.create_time = max_ws.max_create_time