oracle语句中把一列的值合并为一个值,用逗号隔开

1、所有版本的Oracle都可以使用wm_concat()函数:

SELECT pos_preeqid,wmsys.wm_concat(to_char(wkid)) FROM worker where pos_preeqid=62 and wkid<40000 GROUP BY pos_preeqid;

2、如果是11g的话,使用listagg() within group() 函数:

SELECT pos_preeqid, ListAgg(to_char(wkid),',') WITHIN GROUP(ORDER BY pos_preeqid) AS xCity FROM worker where pos_preeqid=62 and wkid<40000 GROUP BY pos_preeqid;

评论

暂无评论