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

0 vote269 views1 answer
C# add a textbox in mysql select
SQL
11 votes280 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
3 votes254 views1 answer
Show index table
SQL
1 vote292 views1 answer
Show databases mysql docker
SQL
0 vote269 views1 answer
Sql server list user permissions
SQL
17 votes274 views6 answers
MySQL ORDER BY
SQL
4 votes249 views2 answers
How to delete row in sql
SQL
3 votes267 views1 answer
Oracle apex warn on unsaved changes
SQL
6 votes268 views6 answers
Count mysql
SQL
0 vote261 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL