SELECT liao1, SUBSTR (MAX (SYS_CONNECT_BY_PATH (liao2, ';')), 2) NAME
FROM (SELECT liao1, liao2, rn, LEAD (rn) OVER (PARTITION BY liao1 ORDER BY rn) rn1
FROM (SELECT liao1, liao2, ROW_NUMBER () OVER (ORDER BY liao2) rn
FROM xiaolin5))
START WITH rn1 IS NULL
CONNECT BY rn1 = PRIOR rn
GROUP BY liao1
order by liao1
如
c1 c2
--------------
1 我
1 是
1 谁
2 知
2 道
3 不
……
转换为
1 我是谁
2 知道
3 不