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

6 votes170 views5 answers
Alter table oracle
SQL
0 vote233 views1 answer
Capabilities of sql select statements
SQL
0 vote174 views1 answer
Case insensitive sql
SQL
0 vote176 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote234 views1 answer
Alternative for LIMIT sql
SQL
0 vote285 views1 answer
How to update random rows in sql
SQL
21 votes186 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote171 views1 answer
Postgres week number
SQL
1 vote189 views1 answer
Select random sample sql
SQL
0 vote177 views1 answer
What is SQL data store?
SQL