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

2025-03-22 15:15:50
推荐回答(1个)
回答(1):

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