34,590
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([a] int,[b] nvarchar(23))
Insert #T
select 1,N'测试1' union all
select 1,N'测试2' union all
select 2,N'测试3'
Go
--测试数据结束
SELECT a ,
STUFF(( SELECT ',' + #T.b
FROM #T
WHERE a = a.a
FOR
XML PATH('')
), 1, 1, '') AS b
FROM #T a
GROUP BY a.a