Question

oracle plsql wmsys.wm_concat()函数问题

SELECT t.rc_id,wmsys.wm_concat(t.project_name) as project_name
　　FROM required_collect_detail t where t.rc_id=rc_id
group by rc_id
例如这句话，我讲相同的rc_id 的project_name 在一个字段中以逗号分隔，那么如何去掉project_name 重复的呢？

Answer 1

SELECT x.rc_id,wmsys.wm_concat(x.project_name) as project_name

FROM(

SELECT distinct t.rc_id, t.project_name

FROM required_collect_detail t where t.rc_id=rc_id ) x

group by x.rc_id