17,086
社区成员
发帖
与我相关
我的任务
分享
SQL>
SQL> WITH t1 AS(SELECT ID,NAME,row_number()over(PARTITION BY ID ORDER BY ROWID) rn FROM test)
2 SELECT ID,sys_connect_by_path(NAME,',') FROM t1 WHERE connect_by_isleaf=1 START WITH rn=1 CONNECT BY PRIOR rn=rn-1 AND PRIOR ID=ID
3 ;
ID SYS_CONNECT_BY_PATH(NAME,',')
---- --------------------------------------------------------------------------------
1 ,张三,王五
2 ,李四
SQL>