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 vote276 views1 answer
Sql inserted
SQL
0 vote313 views1 answer
Query builder doctrien return sql
SQL
0 vote295 views1 answer
Select count concat string sql server
SQL
1 vote272 views1 answer
Add sequence postgres
SQL
0 vote289 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote285 views1 answer
Sqlite commands
SQL
0 vote310 views2 answers
Sql stored procedure for access frontend
SQL
3 votes303 views1 answer
Locate sql server
SQL
1 vote295 views1 answer
Flask sqlalchemy default value
SQL
2 votes287 views1 answer
Date conversion in mysql column
SQL