[Table1]
ID,Name
1,aaa
2,bbb
3,ccc
4,ddd
5,eee
6,fff
7,gggselect Name from Table1 where ID in(2,3,4)取出行数据
bbb
ccc
ddd我想要bbb,ccc,ddd这样的格式,即把查询到的结果合并到1行用逗号分隔,请问如何处理?
ID,Name
1,aaa
2,bbb
3,ccc
4,ddd
5,eee
6,fff
7,gggselect Name from Table1 where ID in(2,3,4)取出行数据
bbb
ccc
ddd我想要bbb,ccc,ddd这样的格式,即把查询到的结果合并到1行用逗号分隔,请问如何处理?
select @name = isnull(@name + ',','') + Name from Table1 where ID in(2,3,4)select @name as name
select @str=@str+name+',' Table1 where ID in(2,3,4)
select substring(@str,1,len(@str)-1)
declare @s varchar(8000)
select @s=isnull(@s,'')+rtrim(Name)+',' from Table1 where ID in(2,3,4)
select @s as result
set @nname=''
select @nname=@nname+','+[Name] from Table1 where ID in(2,3,4)
select @nname
好像可以 没环境 就不写了
谢谢各位,我试了下以下语句可以,不知还有更优的方案吗select distinct names=stuff((select ','+name from Table1 where name in(2,3,4) for xml path('')), 1, 1, '')
from (select name from Table1 where name in(2,3,4)) tb