PostgreSQL 8.4 ROW_NUMBER()函数

SELECT id_card, max_event_num AS event_num, argMax(id, event_num) AS id, argMax(case_no, event_num) AS case_no, argMax(case_name, event_num) AS case_name, argMax(person_name, event_num) AS person_name, argMax(app_name, event_num) AS app_name, argMax(collect_id, event_num) AS collect_id, argMax(from_collect_id, event_num) AS from_collect_id, argMax(account, event_num) AS account, argMax(account_nick, event_num) AS account_nick, argMax(self_account, event_num) AS self_account, argMax(self_account_nick, event_num) AS self_account_nick, argMax(right_account, event_num) AS right_account, argMax(right_account_nick, event_num) AS right_account_nick, argMax(label_target_code, event_num) AS label_target_code, groupArray(DISTINCT case_no || ':' || case_name) AS case_info_list_str, groupArray(DISTINCT person_name || '|' || from_collect_id) AS person_info_list_str FROM ( SELECT *, row_number() OVER (PARTITION BY from_collect_id ORDER BY event_num DESC) AS rn FROM ph_eeanalysis.yx_label_trace_case_network FINAL WHERE tnt = 'tiantai' AND collect_id = '331023202505291000013' AND rule_code = '07000020101' AND account = 'wxid_r0u94i5by82921' AND from_collect_id != collect_id ) AS filtered WHERE rn = 1 GROUP BY id_card, max_event_num ORDER BY event_num DESC LIMIT 10 OFFSET 0; 你看我这个运行报错怎么给我处理，能不能给我解决好，SQL 错误 [22000]: Code: 184. DB::Exception: Aggregate function argMax(case_no, max_event_num) is found inside another aggregate function in query: While processing argMax(case_no, max_event_num AS event_num) AS case_no. (ILLEGAL_AGGREGATION) (version 21.11.8.4 (official build))

mysql8.4