SELECT TABLE1.A, TABLE1.B, TABLE1.C
FROM TABLE1,
(
SELECT A, MAX(C) as C FROM TABLE1
GROUP BY A
) AS MAX_DATA

WHERE TABLE1.A = MAX_DATA.A AND TABLE1.C = MAX_DATA.C