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
你可能喜欢:
继续浏览有关 数据库技术文章/教程 的文章
发表评论