一列包含ID,对于同一ID,它们的名称不同。
ID Name
1 Amrutha
1 Ankith
1 Lalitha
1 Kavitha
2 Nithin
2 Raghu
2 Pramodh
结果应该是
1 Amrutha,Ankitha,Lalitha,Kavitha
2 Nithin,Raghu,Pramodh
请帮我做这个。我在使用Groupby子句时出错了。
select
id,
stuff(
( Select ','+t.name from t where t.id = b.id for xml path ('') ),
1, 1, ''
) as dept
from t b
group by id