[阅读: 508] 2004-11-11 08:12:11
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
DISSENT IS THE HIGHEST FORM OF PATRIOTISM !
--Thomas Jefferson