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 vote262 views1 answer
Sql sum show 0 result
SQL
0 vote202 views1 answer
Oracle last user logon
SQL
0 vote282 views1 answer
Dataframe lambda elif
SQL
3 votes272 views2 answers
Search text in all sql server stored procedure
SQL
0 vote243 views1 answer
Postgresql copy backup table
SQL
0 vote251 views1 answer
Mysql two joins
SQL
2 votes264 views1 answer
How to get non distinct values in sql
SQL
0 vote250 views1 answer
Get number of tables in database sql
SQL
17 votes270 views4 answers
Mysql remove ubuntu
SQL
0 vote297 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL