Group by 分组后合并数据

CREATE TABLE #test(id varchar(50), [values] varchar(10))

INSERT #test SELECT '001', 'aa'

UNION ALL SELECT '001', 'bb'

UNION ALL SELECT '002', 'aaa'

UNION ALL SELECT '002', 'bbb'

UNION ALL SELECT '002', 'ccc';

select * from #test For XML PATH('')


SELECT id, data=stuff((SELECT ','+[values] FROM #test t WHERE id=t1.id FOR XML PATH('')),1,1,'')

FROM #test t1

GROUP BY id