oracle 查找某字段汇总后的最大值及其对应的另一个字段值

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