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

6 votes150 views2 answers
Foreign key sqlite3 python
SQL
6 votes153 views4 answers
Mysql group by date
SQL
0 vote168 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
-1 vote211 views1 answer
Get month and year from date in mysql sequelize
SQL
1 vote150 views1 answer
Oracle apex run 404
SQL
17 votes151 views4 answers
Postgres list users
SQL
0 vote160 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote105 views2 answers
Avg() sql
SQL
1 vote139 views1 answer
Oracle add proxy
SQL
1 vote149 views1 answer
List all triggers in SQL Server
SQL