本来的数据为
select * from wx_rengong
想实现的结果为.
语句为:
select wx_in_id,code,STUFF((select ',' + zyxm from wx_rengong where code=A.code FOR XML PATH('')),1,1,'') as zyxm
from( select wx_in_id,code from wx_rengong)A group by wx_in_id,code.
理解:首先要把 code与 wx_in_id 分组显示,
即:
select wx_in_id,code,zyxm from wx_rengong group by wx_in_id,code, zyxm
结果:
然后:在分组结果中对其进行合并,加上条件 where code =A.code即可!
参考文档:SQL进阶: for xml path('')的使用,sql多条合并为一条,且不损失数据_咯好好的博客-CSDN博客sqlserver 之STUFF的运用_陌陌陌上花开的博客-CSDN博客