sql server 怎么实现mysql中group_concat,列转行,列用分隔符拼接字符串

create table tb(id int, value varchar(10))
insert into tb values(1, 'aa')
insert into tb values(1, 'bb')
insert into tb values(2, 'aaa')
insert into tb values(2, 'bbb')
insert into tb values(2, 'ccc')
go

SELECT * from tb;

select id, [value] = stuff((select ',' + [value] from tb t where id = tb.id for xml path('')) , 1 , 1 , '')
from tb
group by id

drop table tb

上一篇:ORA-06575:程序包或函数处于无效状态


下一篇:Razor Page Library:开发独立通用RPL(内嵌wwwroot资源文件夹)