SELECT b.列1,LEFT(List,LEN(List)-1) as Num FROM (SELECT 列1,(SELECT 列2+',' FROM 表 WHERE 列1=a.列1 FOR XML PATH('')) AS ListFROM 表 a GROUP BY 列1) b
