怎么将一个表搜出来的一列转换成用逗号分隔的一行？

[孙月魂]

比如：
表t1 表t2
A B C D
3 2 3 6
3 4 7 8

通过类似select C,D,xxxxxx F from (select B from t1 where A=t2.c) t3,t2
让结果变为：
C D F
3 6 2,4


要怎么做？

[sych888]

SQL> select deptno,wm_concat(ename) bb from emp group by deptno; DEPTNO BB ---------- -------------------------------------------------- 10 CLARK,KING,MILLER 20 SMITH,FORD,ADAMS,SCOTT,JONES 30 ALLEN,BLAKE,MARTIN,TURNER,JAMES,WARD

[CT_LXL]

引用 楼主 speak13579 的回复:

比如： 表t1 表t2 A B C D 3 2 3 6 3 4 7 8 通过类似select C,D,xxxxxx F from (select B from t1 where A=t2.c) t3,t2 让结果变为： C D F 3 6 2,4 要怎么做？

with t1 as
 (select 3 A, 2 B FROM DUAL UNION ALL SELECT 3 A, 4 B FROM DUAL),
T2 AS
 (select 3 C, 6 D FROM DUAL UNION ALL select 7 C, 8 D FROM DUAL)
SELECT C, D, MAX(F)F
  FROM (SELECT T2.C, T2.D, TO_CHAR(wm_concat(T1.B) OVER(ORDER BY T1.B)) F
          FROM T1, T2
         WHERE T1.A = T2.C)
 GROUP BY C, D;

[huangdh12]

SELECT C,D,WM_CONCAT(A) FROM (Select t2.C,T2.D ,T1.A FROM T1,T2 WHERE T1.A = T2.C) T3 GROUP BY C,D

[孙月魂]

多谢大家