使用解析函数COUNT来计算每个account_id中fund_id的DISTINCT数量：

SELECT account_id,
       fund_id
FROM   (
  SELECT account_id,
         fund_id,
         COUNT(DISTINCT fund_id) OVER (PARTITION BY account_id) AS num_funds
  FROM   table_name
)
WHERE  num_funds > 1;

字符串
其中，对于样本数据：

CREATE TABLE table_name (account_id, Fund_id) AS
SELECT 'ASC23454', 765432 FROM DUAL UNION ALL
SELECT 'ASC67654', 988776 FROM DUAL UNION ALL
SELECT 'ASC23454', 899098 FROM DUAL UNION ALL
SELECT 'ASC23454', 765787 FROM DUAL UNION ALL
SELECT 'ASC90878', 899877 FROM DUAL UNION ALL
SELECT 'ASC90878', 788978 FROM DUAL UNION ALL
SELECT 'ASC98765', 889909 FROM DUAL UNION ALL
SELECT 'ASC09876', 908990 FROM DUAL;

型
产出：
| 联系我们|基金_ID|
| --|--|
| ASC23454| 765432 |
| ASC23454| 765787 |
| ASC23454| 899098 |
| ASC90878| 788978 |
| ASC90878| 899877 |
fiddle