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

4 votes287 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote285 views2 answers
Starts and end with vowel sql
SQL
5 votes282 views1 answer
Invalid column name sql
SQL
0 vote266 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
3 votes221 views1 answer
How to get list of synonyms in oracle
SQL
0 vote259 views1 answer
Snap craft
SQL
0 vote265 views1 answer
Search column name sql
SQL
3 votes270 views2 answers
Mysql create database
SQL
0 vote276 views2 answers
Unique key
SQL
0 vote275 views1 answer
How much space does sql server take per row
SQL