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

0 vote341 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
8 votes309 views4 answers
Mysql update one table from another table multiple columns
SQL
1 vote310 views1 answer
Last 6 months postgresql
SQL
1 vote316 views1 answer
Top 10 rows in mysql
SQL
5 votes321 views1 answer
Sql select ciunt
SQL
2 votes341 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote309 views1 answer
Get foreign table names mysql
SQL
0 vote313 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote339 views1 answer
Print hello world in plsql
SQL
-1 vote345 views3 answers
PS5
SQL