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 votes338 views3 answers
Create table in microsoft sql server
SQL
0 vote346 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote359 views1 answer
Amount of entries in a table psql
SQL
0 vote328 views1 answer
Mysql use password error
SQL
1 vote311 views1 answer
Mysql collation
SQL
4 votes392 views4 answers
Check constraint in ms sql
SQL
0 vote328 views1 answer
Mysql conf.d exampel
SQL
0 vote307 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote325 views1 answer
Number(10 2) in sql means
SQL
0 vote321 views3 answers
Get count of null in column sql
SQL