SELECT 字段1, stuff((SELECT ',' + [字段2] FROM 表 t WHERE t.字段1 = a.字段1 FOR xml path('')) , 1 , 1 , '') as ‘ssss’FROM 表 aGROUP BY 字段1
200字范文,内容丰富有趣,生活中的好帮手!
时间:2024-04-18 08:11:56
SELECT 字段1, stuff((SELECT ',' + [字段2] FROM 表 t WHERE t.字段1 = a.字段1 FOR xml path('')) , 1 , 1 , '') as ‘ssss’FROM 表 aGROUP BY 字段1