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 vote163 views1 answer
Alter rename command in mysql
SQL
0 vote180 views1 answer
How much space does sql server take per row
SQL
12 votes146 views2 answers
Delete all nodes neo4j
SQL
4 votes156 views1 answer
Wilayah indonesia database
SQL
0 vote150 views1 answer
What is the difference between now() and current_date()?
SQL
1 vote239 views1 answer
Oracle datafile max size 32gb
SQL
2 votes249 views1 answer
Postgresql group by month and year
SQL
2 votes200 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote170 views1 answer
Datagrip go to line
SQL
5 votes174 views2 answers
Postgresql insert select
SQL