SQL 分组后拼接字符串

小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

with t  as(

select 'Charles' parent, 'William' child union

select 'Charles', 'Harry' union

select 'Anne', 'Peter' union

select 'Anne', 'Zara' union

select 'Andrew', 'Beatrice' union

select 'Andrew', 'Eugenie'

)

SELECT parent,

STUFF(

     (

      SELECT ','+ child FROM t a WHERE b.parent = a.parent FOR XML PATH('')

     ),1 ,1, '') children

FROM t b

GROUP BY parent

原表：