摘要： sql语句：select column1,column2=stuff((select ','+column2 from table1 where column1=t1.column1 for xml path('')),1,1,'')from table1 t1group by column1 阅读全文