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 vote150 views1 answer
Sqlplus change user
SQL
1 vote148 views1 answer
Spark sql concatenate string and int
SQL
10 votes136 views3 answers
Join multiple tables sql
SQL
0 vote181 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
1 vote171 views1 answer
Sql and
SQL
0 vote165 views2 answers
Sqlalchemy default value for column
SQL
2 votes147 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote192 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote114 views1 answer
Mariadb list tables
SQL
6 votes182 views2 answers
Subtr Oracle ?
SQL