求一SQL语句的写法,不难,谢谢帮忙.

[gshope]

ID content
1 aa
2 bb
3 cc
1 dd
2 ee
3 ff

按照ID分组,把content的内容合并起来(中间加上","),结果如下:
ID content
1 aa,dd
2 bb,ee
3 cc,ff
用一句SQL怎么写??
我想到 select ?? from table group by ID,关键是??怎么写呢??

[gshope]

to Pandahai(飞雪)
你的写法明显不对，你的结果是：
ID content
1 aa,dd
1 dd,aa
2 bb,ee
2 ee,bb
....以下类似，明显不对！！

[子陌红尘]

--生成测试数据
create table t(ID int,content varchar(20))
insert into t select 1,'aa'
insert into t select 2,'bb'
insert into t select 3,'cc'
insert into t select 1,'dd'
insert into t select 2,'ee'
insert into t select 3,'ff'
go

--创建用户定义函数
create function f_str(@ID int)
returns varchar(8000)
as
begin
declare @ret varchar(8000)
set @ret = ''
select @ret = @ret + ',' + content from t where id=@id
set @ret = stuff(@ret,1,1,'')
return @ret
end
go


--执行查询
select ID,content=dbo.f_str(ID) from t group by ID

--输出结果
ID content
---- -------
1 aa,dd
2 bb,ee
3 cc,ff

[GRLD8888]

select top 3 b.id,a.content+','+b.content content from table1 a join table1 b
on a.id=b.id and a.content!=b.content

[GRLD8888]

你的这种查询记录的方法，最常用的方法就是
创建一个函数，然后调用就可以啦

create function f1(@a int)
returns varchar(8000)
as
begin
declare @r varchar(8000)
set @r=''
select @r=@r+','+content from table1 where id=@a
return(stuff(@r,1,1,''))
end
go
--调用实现查询
select id,content=dbo.f1(id) from table1 group by id

[ghostzxp]

如果建个函数就好处理了
create function GetContent
(@ID int)
AS
Begin
Declare @sql nvarchar(4000)
select @sql=@sql+','+content from 表 where id=@id
return @sql
End

select distinct id,dbo.GetContent(id) from 表

[Pandahai]

這樣就可以:
select top 3A.idno,A.content+';'+B.content from test A
left join test B on A.idno=B.idno and A.content!=B.content

[Pandahai]

不好意意,上条写错了一点:
select top 3 A.ID,A.content+';'+B.content from test A
left join test B on A.ID=B.ID and A.content!=B.content