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

10 votes175 views2 answers
Mysql select timestamp group by day
SQL
0 vote233 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote201 views1 answer
Mariadb search columns
SQL
14 votes201 views3 answers
Sql trim from string
SQL
0 vote189 views1 answer
Sql gather statistics to increase performance
SQL
2 votes215 views2 answers
How to run postgresql in linux
SQL
-1 vote249 views1 answer
Search all sql tables for a value
SQL
0 vote217 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote257 views1 answer
Mysql enter ubuntu
SQL
0 vote236 views1 answer
Psql create usr
SQL