订阅sql中怎样把同一张表中相同字段的内容合并为一条记录？并统计数量
来源：网络收集 点击： 时间：2024-02-2712SELECT Customer_ID,Customer_Name,a href=https://www.baidu.com/s?
wd=STUFFtn=44039180_cprfenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y3ujRkn1R1uW9hryN-
njF90ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnHm1rH04rH6snjnkn1mYnjR3n0 target=_blank
class=baidu-highlightSTUFF/a((SELECT ,+Linkman_Name FROM Linkman WHERE Customer_ID=Customer.Customer_ID FOR XML a href=
https://www.baidu.com/s?wd=PATHtn=44039180_cprfenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y3ujRkn1R1uW9hryN-
njF90ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnHm1rH04rH6snjnkn1mYnjR3n0 target=_blank
class=baidu-highlightPATH/a()),1,1,) Linkman_Name FROM Customer
把表名tt换下就可以了购买产品id是字符串类型的话用这个select a.客户id,stuff((select ,+购买产品id from tt b wherea.客户id=b.客户id for XML path() ),1,1,) gg from tt a group by a.客户id
如果购买产品id是整型的话，用这个select a.客户id,stuff((select ,+cast(购买产品id as nvarchar(max)) from tt b wherea.客户id=b.客户id for XML path() ),1,1,) gg from tt a group by a.客户id
参考资料；百度百科-sql
版权声明：
1、本文系转载，版权归原作者所有，旨在传递信息，不代表看本站的观点和立场。
2、本站仅提供信息发布平台，不承担相关法律责任。
3、若侵犯您的版权或隐私，请联系本站管理员删除。
4、文章链接：http://www.1haoku.cn/art_156933.html
