Sql quary stuf

SELECT ID,  abc = STUFF(
             (SELECT ',' + name 
              FROM temp1 t1
              WHERE t1.id = t2.id
              FOR XML PATH (''))
             , 1, 1, '') from temp1 t2
group by id;

Source: stackoverflow.com

Similar codes

1 vote171 views1 answer
How to remove identity from a column in sql server
SQL
1 vote191 views1 answer
Sql set auto increment back to 0
SQL
5 votes190 views3 answers
String concatenation sql server
SQL
0 vote173 views1 answer
Get time component of datetime sql
SQL
3 votes177 views2 answers
Laravel tosql with bindings
SQL
2 votes240 views3 answers
3 days back in sql server
SQL
0 vote263 views1 answer
Having all mysql
SQL
20 votes215 views4 answers
How to find average in sql
SQL
0 vote198 views1 answer
Query to insert image
SQL
2 votes167 views1 answer
Sql find missing values between two tables
SQL