有一张D表,字段和数据如下 ID PN RN MPN --------- ---------- ---------- ---------- 1 a1 2 a1 1 a2 3 a1 1 a3 4 a1 select d.id,max(sys_connect_by_path(d.pn,',')) as pn from d start with d.pn=d.mpn connect by prior d.rn=d.rn-1 group by id; 执行: ID PN ---- ----- 1 ,a1,a2,a3 不知道对你能不能有点帮助?
ID PN RN MPN
--------- ---------- ---------- ----------
1 a1 2 a1
1 a2 3 a1
1 a3 4 a1
select d.id,max(sys_connect_by_path(d.pn,',')) as pn
from d
start with d.pn=d.mpn
connect by prior d.rn=d.rn-1
group by id;
执行: ID PN
---- -----
1 ,a1,a2,a3
不知道对你能不能有点帮助?