select ID,Name, TEST = STUFF((SELECT ';'+xx FROM emps where ID=t.ID FOR XML PATH('')),1,1,'') from emps t group by ID,Name
Sqlserver 多行合并成一行
发布时间 2023-12-13 11:24:25作者: LiXiang98
select ID,Name, TEST = STUFF((SELECT ';'+xx FROM emps where ID=t.ID FOR XML PATH('')),1,1,'') from emps t group by ID,Name