SELECT AAA.A,AAA.B,AAA.C,AAA.D
FROM 表 AAA
Inner join
(
SELECT A, MAX(C) as CC,Max(D) as DD FROM 表
GROUP BY A
) AS BBB
On AAA.A = BBB.A AND AAA.C = BBB.CC And AAA.D = BBB.DD