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 vote188 views1 answer
Watch mysql command line
SQL
1 vote195 views1 answer
Oracle nvl2
SQL
0 vote216 views1 answer
How to drop a trigger in postgresql
SQL
0 vote196 views1 answer
Window function to forward fill
SQL
0 vote177 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
32 votes194 views6 answers
Sql count where
SQL
0 vote236 views1 answer
Sql to excel pgadmin
SQL
26 votes187 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote242 views1 answer
Prisma transaction
SQL
0 vote349 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL