比如我有表b
name id
___________________
aaa 2
aaa 2
aaa 3
bbb 2
bbb 3
bbb 4
使理后得到
name id
——————————
aaa 2,2,3
bbb 2,3,4
SELECT name,MAX(SYS_CONNECT_BY_PATH (id,'、'))sc
FROM (
SELECT name,id, ROW_NUMBER()OVER (PARTITION BY name ORDER BY id)rn
FROM B)
GROUP BY name
START WITH rn=1
CONNECT BY PRIOR rn=rn-1 AND PRIOR name=name