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 vote161 views1 answer
Mysql utc timestamp
SQL
0 vote161 views1 answer
Drop index in sql
SQL
0 vote123 views2 answers
Android sqlite query join
SQL
0 vote155 views1 answer
Pl sql round
SQL
23 votes158 views6 answers
Create table sql server
SQL
0 vote164 views1 answer
Merge clause with inner join
SQL
0 vote168 views1 answer
Sql select sum group by id laravel join
SQL
8 votes112 views1 answer
Similarities between ddl and dml
SQL
37 votes167 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
2 votes141 views1 answer
Drop table if exists in postgres
SQL