数据库将多行数据合并为一行数据

先看数据库:

假如我们执行这样的语句 select * from sh_meetingservice where id in(1,2,3);结果如下会有多行

但是我们想要多行合并为一行,我们需要用到 for xml path

select text+',' from sh_meetingservice  where id in (1,2,3) for xml path('myApp');

 

for xml path('')节点为空;for xml path默认;for xml path('myApp')自定义返回

然后在执行

select (select text+',' from sh_meetingservice  where id in (1,2,3) for xml path('')  ) as txt ;