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 vote136 views1 answer
Sql period overlap
SQL
0 vote87 views1 answer
How to set field to null in sql
SQL
0 vote124 views3 answers
Remove folders from remote git
SQL
0 vote138 views1 answer
Where name ends in SQL
SQL
0 vote130 views1 answer
Import all databases mysql
SQL
0 vote156 views1 answer
Select all same column value in sql
SQL
3 votes122 views1 answer
Start mysql server linux terminal
SQL
0 vote168 views1 answer
Sql count matching group by
SQL
4 votes139 views3 answers
Mysql modify foreign key
SQL
0 vote120 views1 answer
Mysql database is not starting in xampp
SQL