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 vote147 views1 answer
Mysql change root mysql_native_password
SQL
1 vote139 views1 answer
Mariadb get column names from table
SQL
-1 vote149 views2 answers
Full join sql
SQL
0 vote150 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
53 votes343 views6 answers
How to install mysql ubuntu
SQL
0 vote134 views1 answer
Mysql return column names when table is empty
SQL
11 votes135 views2 answers
Oracle all source
SQL
1 vote158 views1 answer
Oracle sequence last_number
SQL
0 vote136 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote132 views1 answer
Oracle for loop on list
SQL