SELECT *
FROM
(
    SELECT MAX(SUM) maxsum, fkid
    FROM xxx
    GROUP BY fkid
) t1
INNER JOIN xxx t2 ON t2.SUM = t1.SUM AND t2.fkid = t1.fkid