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 vote183 views1 answer
Sql server epoch to datetime
SQL
0 vote175 views1 answer
On update current_timestamp jpa
SQL
0 vote164 views1 answer
Transaction database with php
SQL
0 vote165 views1 answer
Oracle current timestamp
SQL
1 vote265 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote169 views1 answer
Sql server check whether column has same equal values
SQL
0 vote174 views1 answer
Mysql create index lost connection
SQL
0 vote169 views1 answer
How many columns can be used for creating index?
SQL
0 vote189 views1 answer
Function plsql
SQL
7 votes166 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL