字符串分组聚合

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   

 

原始出处:http://www.cnblogs.com/jintan/archive/2009/07/17/1525895.html

 

转载于:https://www.cnblogs.com/lenya/archive/2011/06/23/3706535.html