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 vote118 views1 answer
Default order by in mysql
SQL
2 votes113 views1 answer
Oracle find unusable indexes
SQL
0 vote130 views1 answer
Redshift running queries
SQL
0 vote120 views1 answer
Original Query
SQL
0 vote121 views1 answer
Sql select min
SQL
7 votes109 views3 answers
SQL create a new table
SQL
1 vote155 views1 answer
Mysql tables max count
SQL
0 vote116 views4 answers
Restart MySQL
SQL
1 vote118 views1 answer
Window function mysql
SQL
4 votes114 views1 answer
Datepart postgres
SQL