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

3 votes153 views2 answers
Mysql config user password
SQL
0 vote145 views1 answer
How to check if there is no database schema
SQL
0 vote189 views1 answer
Get initials name in sql
SQL
0 vote168 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote140 views1 answer
Sqlite3 now
SQL
2 votes154 views1 answer
Pandas to sql index
SQL
0 vote152 views1 answer
Postgres populate table from another table
SQL
0 vote155 views2 answers
How to count codition
SQL
0 vote151 views1 answer
Mysql select where field like in list
SQL
0 vote150 views1 answer
Mysql uuid
SQL