17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT cod_a, SUBSTR (MAX (SYS_CONNECT_BY_PATH (cod_b, ';')), 2) NAME
FROM (SELECT cod_a, cod_b, rn, LEAD (rn) OVER (PARTITION BY cod_a ORDER BY rn) rn1
FROM (SELECT cod_a, cod_b, ROW_NUMBER () OVER (ORDER BY cod_b) rn
FROM codd))
START WITH rn1 IS NULL
CONNECT BY rn1 = PRIOR rn
GROUP BY cod_a;
select cod_a,wmsys.wm_concat(cod_b) from codd group by cod_a;