SELECT parent.ColumnA,
(
SELECT child.ColumnB + ','
FROM [YourTable] child
WHERE child.ColumnA = parent.ColumnA
FOR XML PATH('')
) AS 'CombinedColumnB'
FROM [YourTable] parent
GROUP BY parent.ColumnA
请注意:
1. 内外在同一表中: [YourTable]
2. Where条件中的列指的是基准列