场景一 某表中 id，name，sex 根绝 id 分组 将一组的name 相加用逗号隔开 将sex 相加用逗号隔开
用到的sql 函数 for xml 和 STUFF
SELECT
id,
[name] = stuff(
(
SELECT
‘,‘ + [name]
FROM
tabla AS a
WHERE
a.name = b.namefor xml path (‘‘)
),
1,
1,
‘‘
),
[sex] = stuff(
(
SELECT
‘,‘ + [sex]
FROM
tabla AS a
WHERE
a.id = b.id FOR xml path (‘‘)
),
1,
1,
‘‘
)
FROM
tabla AS b
GROUP BY
id
常用sql 汇总--- SQL 根据一个字段分组后，把另外几个字段的字符串累加连接起来
原文：https://www.cnblogs.com/lwycaoyu/p/12767392.html