SELECT * FROM (SELECT T.AAAA, SUM(T.BBBB) FROM T_TABLE_NAME T GROUP BY T.AAAA ORDER BY SUM(T.BBBB) DESC) WHERE ROWNUM = 1