如何把重复的列数据转换为一行数据，不重复的以逗号隔开，作为一列

select cc.guid,cc.Project_Id, wm_concat(cc.ZMC ) zmc from (

select distinct ZDPR_ZXXM.guid,ZDPR_ZXXM.Project_Id,ZDPR_ZXCBS.ZMC from ZDPR_ZXXM ZDPR_ZXXM ,ZDPR_ZXCBS ZDPR_ZXCBS where ZDPR_ZXCBS.ZCBSBM=ZDPR_ZXXM.Zcbsbm and ZDPR_ZXCBS.ZCBSTYPE=30

and ZDPR_ZXXM.project_id='130120160003' ) cc group by cc.guid,cc.project_id

方法： wm_concat 和 listagg （Oracle 可以）

select guid,project_id, wmsys.wm_concat(zmc) zmc from xxxx group by guid,project_id