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

11 votes298 views2 answers
Oracle all source
SQL
3 votes311 views1 answer
Set default today mysql
SQL
5 votes355 views1 answer
Mysql count lines
SQL
0 vote327 views1 answer
What is initial catalog in sql connection string
SQL
2 votes297 views1 answer
Mysql time ago difference
SQL
0 vote295 views1 answer
Sql server select ignore dupplicates
SQL
3 votes293 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote291 views1 answer
10000000000000000000 am to meters
SQL
1 vote321 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes315 views1 answer
Null sql
SQL