跟李大师的答案一样
SELECT 表1.A, 表1.B, 表1.C
FROM 表1
join
(
SELECT A, MAX(C) as C FROM 表1
GROUP BY A
) AS D
on 表1.A = D.A AND 表1.C = D.C