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;

评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论