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 vote182 views1 answer
Postgres reorder columns
SQL
3 votes163 views1 answer
Créer une table sql
SQL
0 vote194 views1 answer
Oracle step procedure
SQL
2 votes162 views1 answer
Plsql block
SQL
0 vote215 views1 answer
What does the -p flag do in mysql cli
SQL
16 votes211 views3 answers
Order by sql query
SQL
7 votes168 views3 answers
Sql fill table with info from anothe rtable
SQL
1 vote201 views3 answers
How to update column name in psql
SQL
0 vote179 views1 answer
Can we rollback data that are deleted using DELETE
SQL
20 votes182 views6 answers
Mysql reset auto increment
SQL