根据相同ID，对字符串列进行聚合【mysql,mssql】

发布时间：2020-12-13 19:57:13 所属栏目：百科来源：网络整理

导读：TableA ID Names 1 n1 2 n2 1 nn2 2 nn3 3 nn4 1 nn1 ID相同的记录，对Names进行聚合得到结果是： ID SumNames 1 n1,nn2,nn1 2 n2,nn3 3 nn4 mysql select id,group_concat(names) from tableA group by id; mssql select stuff((select ','+names from tab

TableA

ID Names

1 n1

2 n2

1 nn2

2 nn3

3 nn4

1 nn1

ID相同的记录，对Names进行聚合

得到结果是：

ID SumNames

1 n1,nn2,nn1

2 n2,nn3

3 nn4

mysql

select id,group_concat(names) from tableA group by id;

mssql

select stuff((select ','+names from tableA as t2 where t2.id=t1.id for xml path('')),1,1) from (select id,names from tableA as t1 group by id);

select stuff(

(select ','+convert(Varchar(50),MemberGuid) from (SELECT a.MemberGuid,a.managerguid,b.UserName FROM membermanager a LEFT JOIN k_manager b ON a.managerguid = b.managerguid) as t2 where t2. MemberGuid = t1.MemberGuid FOR XML PATH('')),'' ) from (SELECT a.MemberGuid,b.UserName FROM membermanager a LEFT JOIN k_manager b ON a.managerguid = b.managerguid) as t1 where memberguid=@MemberGuid group by memberguid

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!