求行合并的SQL

[tomcat]

有一个表结构如下
col1 col2 col3
--------------
a b c
a b d
e f g
e f h

想求一条sql
搜索之后的结果为
col1 col2 col3
--------------
a b c,d
e f g,h

十分感谢~

[HSBOY86]

http://topic.csdn.net/u/20101026/09/b772f4a6-89ba-4f22-a980-1112747fa730.html

这里有类似的

[PxxxP]

--> 测试数据：[TB]
if object_id('[TB]') is not null drop table [TB]
create table [TB]([col1] varchar(1),[col2] varchar(1),[col3] varchar(1))
insert [TB]
select 'a','b','c' union all
select 'a','b','d'

select ','+col3 from tb for xml path('')

select 
	col1,
	col2,
	col3=stuff((select ','+col3 from tb where t.col1=col1 and t.col2=col2 for xml path('')) ,1,1,'')
from [TB] t
group by col1,col2

/*
col1 col2 col3
---- ---- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
a    b    c,d

(1 行受影响)


*/
drop table [TB]

[tomcat]

感谢两位的帮忙，十分感谢~

[viqn7qdnt]

select col1,col2,
col3=stuff((select ','+col3 from tb where t.col1=col1 and t.col2=col2 for xml path('')) ,1,1,'')
from 表 t
group by col1,col2