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

kavin Python 2023-02-27 617浏览 0

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

转载请注明：IT运维空间 » Python » sql server 怎么实现mysql中group_concat,列转行,列用分隔符拼接字符串

继续浏览有关数据库技术文章/教程的文章

发表评论