SELECT 字段1, stuff((SELECT ',' + [字段2] FROM 表 t WHERE t.字段1 = a.字段1 FOR xml path('')) , 1 , 1 , '') as ‘ssss’FROM 表 aGROUP BY 字段1
900字范文,内容丰富有趣,生活中的好帮手!
时间:2020-01-25 07:38:23
SELECT 字段1, stuff((SELECT ',' + [字段2] FROM 表 t WHERE t.字段1 = a.字段1 FOR xml path('')) , 1 , 1 , '') as ‘ssss’FROM 表 aGROUP BY 字段1