[color=#FF0000]关于sql 行转列问题[/color]

[HolyPlace]

如何将这个结果
groupid colorid
1 2
1 3
1 4

转成这样
groupid colorid
1 2 3 4

不要贴网上那些查成绩的，直接上sql吧

[宝_爸]

你这个好像不是行列转换，可能没法用PVOIT.

[HolyPlace]

看网上的行转列一般都使用了聚合函数等，不知道这个怎么搞

[wisdonlz]

换一种思维:如果你是想要这种结果，你可以读出来，再判断处理，就可以得到这种结果啦，如果不是，那还得高手来解决了

[wuyq11]

字符串拼接
declare @s varchar(100)
select @s=isnull(@s+'','')+col from tb
select @s

[罗纳尔迪尼奥]

select distinct c.[groupid] as [groupid],
(select [colorid] from [Table_1] where [groupid] = 1 and [colorid]=2 )as [colorid],
(select [colorid] from [Table_1] where [groupid] = 1 and [colorid]=3)as [colorid],
(select [colorid] from [Table_1] where [groupid] = 1 and [colorid]=4 )as [colorid]
from [Table_1] c

[罗纳尔迪尼奥]

[Table_1] 的数据就是

groupid colorid
1 2
1 3
1 4

[HolyPlace]

[Quote=引用 5 楼 cnna002a 的回复:]
select distinct c.[groupid] as [groupid],
(select [colorid] from [Table_1] where [groupid] = 1 and [colorid]=2 )as [colorid],
(select [colorid] from [Table_1] where [groupid] = 1 and [colorid]=3)as ……
[/Quote]
这样写是不是太特殊了

[NDDavid]

字符串拼接？