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 votes129 views1 answer
No data found oracle
SQL
0 vote130 views1 answer
Mysql select where field is a value
SQL
0 vote141 views1 answer
Postgresql import a database of gzip
SQL
0 vote126 views1 answer
Nvl2 syntax
SQL
8 votes130 views2 answers
Oracle undo usage
SQL
1 vote143 views1 answer
Mysql not supported auth mode
SQL
0 vote128 views1 answer
Oracle table privileges
SQL
1 vote132 views3 answers
Reset sql primary key
SQL
1 vote122 views3 answers
Union in sql
SQL
1 vote118 views1 answer
Create sample data postgresql
SQL