Table is:
| Id |
Firstname |
| 4 |
abc |
| 4 |
def |
| 4 |
ghi |
| 4 |
jkl |
| 4 |
mno |
Required output:
| Id |
Name |
| 4 |
abc,def,ghi,jkl,mno |
Query:
SELECT ID,
Name = STUFF(
(SELECT ',' + firstname FROM temp FOR XML PATH ('')), 1, 1, ''
)
FROM temp GROUP BY ID
This query is working but I want to know the reason how it is working or if there is any other way to get this done