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 vote279 views1 answer
Doctors appointment
SQL
0 vote207 views3 answers
Group_concat sql server
SQL
1 vote208 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote208 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
3 votes212 views1 answer
Postgres select max value
SQL
7 votes210 views2 answers
Oracle sql drop index
SQL
0 vote192 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote281 views1 answer
Mysql loop through databases and execute query
SQL
3 votes197 views1 answer
Two selects in one query
SQL
0 vote218 views1 answer
What logs are available on RDS MySQL?
SQL