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

1 vote253 views1 answer
Select users with same username
SQL
13 votes248 views4 answers
What is sql
SQL
0 vote249 views1 answer
SQL joins in python
SQL
1 vote223 views1 answer
Oracle grant on all tables in schema
SQL
0 vote242 views1 answer
Select milliseconds mysql
SQL
1 vote220 views1 answer
Postgresql datetrunc too slow
SQL
1 vote210 views1 answer
Mysql select row with max value group by
SQL
4 votes288 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote238 views1 answer
MySQL update with subquery
SQL
0 vote241 views2 answers
Dbms interview questions
SQL