• Will this help:

    SELECT c1

    FROM(SELECT c1, SUM(c2) AS 'Adding',(ROW_NUMBER() OVER (ORDER BY SUM(c2) DESC)) AS 'Row'

    FROM Table1 t1

    GROUP BY c1) a

    WHERE Row = 1