1 :SELECT STUFF((SELECT ','+字段名 FROM 表名 for xml path('')),1,1,'')
2:CREATE TABLE t1 ( id INT, uid VARCHAR(10) )
insert into t1 values (1,'a')
insert into t1 values (1,'b')
insert into t1 values (1,'b')
insert into t1 values (1,'c')
insert into t1 values (1,'d')
insert into t1 values (2,'a')
insert into t1 values (2,'b')
insert into t1 values (2,'c')
insert into t1 values (2,'c')
insert into t1 values (3,'a')
insert into t1 values (3,'b')
insert into t1 values (3,'c')
insert into t1 values (3,'c')
select id,stuff((select distinct ','+uid from t1 where a.id=id for xml path('')),1,1,'') AS items from t1 a group by id
--查询结果
id items
1 a,b,c,d
2 a,b,c
3 a,b,c