你这个能不能具体点，这样写没办法帮你

字段A  字段B

A             1

A             2

B             1

B             2

B             3

C             1

C             2

D             1

D             2

D             3

匹配出来的结果是，由1和2组成是有A和C,由123组成的有B和D 当然可能有N多个组，分别由不同的数据组成。找出其中组成数据相同的不同的组

WITH TEST 

AS

(

SELECT 'A' name ,1 val FROM DUAL UNION ALL

SELECT 'A',2 FROM DUAL UNION ALL

SELECT 'B',1 FROM DUAL UNION ALL

SELECT 'B',2 FROM DUAL UNION ALL

SELECT 'B',3 FROM DUAL UNION ALL

SELECT 'C',1 FROM DUAL UNION ALL

SELECT 'C',2 FROM DUAL UNION ALL

SELECT 'D',1 FROM DUAL UNION ALL

SELECT 'D',2 FROM DUAL UNION ALL

SELECT 'D',3 FROM DUAL

)

SELECT VALIST,LISTAGG(NAME,',') WITHIN GROUP(ORDER BY VALIST) NAMELIST

from (

select name,listagg(val,',') within group(order by name) valist

FROM TEST

GROUP BY NAME)

GROUP BY VALIST

order by valist;

感谢MOONE专家的指导，已经通过listagg完成了匹配~！