根据相同ID,对字符串列进行聚合【mysql,mssql】
发布时间:2020-05-27 07:25:32 所属栏目:程序设计 来源:互联网
导读: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
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(编辑:安卓应用网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |