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 vote308 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote301 views1 answer
Mysql url data type
SQL
0 vote289 views1 answer
Mariadb number format
SQL
0 vote299 views1 answer
Postgres set default schema
SQL
0 vote317 views2 answers
Dumping sql table
SQL
0 vote309 views1 answer
Closure in sql
SQL
14 votes318 views2 answers
Oracle limit rows
SQL
0 vote287 views1 answer
Query to insert image
SQL
0 vote279 views1 answer
Check mysql password with docker container magento 2
SQL
3 votes311 views1 answer
Sql insert inserted id
SQL