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

2 votes227 views2 answers
Mysql does sentence contain word
SQL
0 vote199 views2 answers
Drop tables from local table database postgres
SQL
0 vote205 views1 answer
Mysql change innodb to myisam
SQL
1 vote194 views1 answer
Mysql select from outside
SQL
58 votes344 views4 answers
Mysql drop column
SQL
0 vote196 views1 answer
Laravel eloquent get generated sql
SQL
3 votes206 views2 answers
Sql server current date without time
SQL
2 votes187 views1 answer
No data found oracle
SQL
1 vote182 views1 answer
Import database from a file using mysql commandline
SQL
0 vote187 views1 answer
How to check replication lag in mySQL
SQL