谢谢6 有的版本似乎不支持这个函数 高手！学习了！ 10g开始支持，10g前用sys_connect_by_path 10g以前不支持wm_concat! SQL code: 测试数据: select * from a; ID SNAME ---------- -------------------------------------------------- 2 yang 4 Riddd 2 ff 4 Hlia 4 Yreer SYS_CONNECT_BY_PATH 适用范围：8i,9i,10g及以后版本 SELECT t.id id, MAX(substr(sys_connect_by_path(t.sname, ','), 2)) str from (SELECT id, sname, row_number() over(PARTITION BY id ORDER BY sname) rn from a) t START WITH rn = 1 CONNECT BY rn = PRIOR rn + 1 AND id = PRIOR id GROUP BY t.id;
结果 ID STR 2 ff,yang 4 Hlia,Riddd,Yreer 10G环境
语句
select a1,replace(wmsys.wm_concat(b1),',','') from k1 group by a1
