display-records-for-one-id-if-there-is-more-number-for-the-same-id, Sql Server

Language: Layout:

;WITH example AS(
    SELECT *
    FROM (VALUES (1265,'MARK'),
                (1265,'LISA'),
                (1265,'MAY'),
                (1264,'LINDA'),  
                (1263,'MARTINA'),
                (1262,'MARKO'),                                                                                                                                                                                
                (1261,'VIDAKS'),
                (1260,'PEEKS'), 
                (1259,'MARCUS'),
                (1258,'MARKO'),                                                                                                                                                                                
                (1257,'MATIA'),                                                                                                                                                                                 
                (1256,'POPOVIC')) e(ID, NUMBER))

SELECT ID, NUMBER = 
    STUFF((SELECT DISTINCT ', ' + NUMBER
           FROM example t2 
           WHERE t2.id = t1.id 
          FOR XML PATH('')), 1, 2, '')
FROM example t1
GROUP BY id
ORDER BY ID DESC

View schema
Execution time: 0 sec, rows selected: 10, rows affected: 0, absolute service time: 0,17 sec