你可以试试像

You can try something like

SELECT DISTINCT a.sno,
 (SELECT STUFF((SELECT ',' + RTRIM(b.Name )
                FROM YourTable b 
                WHERE b.sno = a.sno FOR XML PATH('')),1,1,''))
FROM YourTable a