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 vote285 views1 answer
Change filed order in mysql
SQL
1 vote276 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote265 views2 answers
Create new table plsql
SQL
1 vote281 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
2 votes258 views1 answer
Select * from table where name like
SQL
0 vote270 views1 answer
Oracle list subpartitions
SQL
0 vote277 views3 answers
Query string not ending with with vowels
SQL
8 votes294 views3 answers
SQL column name
SQL
0 vote277 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote265 views2 answers
How to type a blank discord messgae
SQL