sql语句:
select column1,column2=stuff((select ','+column2 from table1 where column1=t1.column1 for xml path('')),1,1,'')
from table1 t1
group by column1
sql语句:
select column1,column2=stuff((select ','+column2 from table1 where column1=t1.column1 for xml path('')),1,1,'')
from table1 t1
group by column1
转载于:https://www.cnblogs.com/xalyf/archive/2012/08/17/2644219.html