Sql roll up rows into columns

SELECT 
   SS.SEC_NAME,
   STUFF((SELECT '; ' + US.USR_NAME 
          FROM USRS US
          WHERE US.SEC_ID = SS.SEC_ID
          ORDER BY USR_NAME
          FOR XML PATH('')), 1, 1, '') [SECTORS/USERS]
FROM SALES_SECTORS SS
GROUP BY SS.SEC_ID, SS.SEC_NAME
ORDER BY 1

Similar codes

1 vote314 views1 answer
Oracle create program if no exists
SQL
4 votes326 views1 answer
Sql any
SQL
0 vote341 views1 answer
How to update date value in sql
SQL
0 vote326 views1 answer
How to connect postgresql database with java
SQL
0 vote333 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote307 views1 answer
Mysql update sum same table
SQL
0 vote344 views1 answer
Sqlalchemy empty table
SQL
4 votes321 views1 answer
Sql group by year
SQL
0 vote382 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote351 views1 answer
Oracle grant create job
SQL