SELECT TOP 1000 [diqu] ,[fuzeren] ,[yugong] FROM [lx].[dbo].[ls]
select diqu,fuzeren,stuff((select ','+yugong from ls where diqu = a.diqu and fuzeren=a.fuzeren
for xml Path('')),1,1,'') as yugong
from ls a
group by diqu,fuzeren
SELECT TOP 1000 [diqu] ,[fuzeren] ,[yugong] FROM [lx].[dbo].[ls]
select diqu,fuzeren,stuff((select ','+yugong from ls where diqu = a.diqu and fuzeren=a.fuzeren
for xml Path('')),1,1,'') as yugong
from ls a
group by diqu,fuzeren
转载于:https://www.cnblogs.com/xiaobaidejiucuoben/p/10221048.html