-- 将符合条件的id 放在where条件后 SELECT id, A, B FROM test AS a WHERE id IN ( SELECT max( b.id ) AS id FROM test AS b GROUP BY b.A )
-- 将符合条件的id 作为子查询 连接自己 SELECT a.id, a.A, a.B FROM test AS a INNER JOIN ( SELECT max( b.id ) AS id FROM test AS b GROUP BY b.A ) c ON a.id = c.id
原文：https://www.cnblogs.com/dw-date/p/14006776.html