sql 合并行

sql语句：

select column1,column2=stuff((select ','+column2 from table1 where column1=t1.column1 for xml path('')),1,1,'')
from table1 t1
group by column1