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

5 votes191 views3 answers
Show indexes mysql
SQL
0 vote171 views1 answer
Add alternate add column sql
SQL
11 votes163 views2 answers
Sql between date range
SQL
0 vote176 views1 answer
Add computed column to table sql server
SQL
4 votes173 views2 answers
Xampp mysql database server is not starting mac m1
SQL
3 votes181 views4 answers
Ubuntu stop mysql
SQL
0 vote145 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote174 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
8 votes207 views6 answers
Insert command in sql
SQL
0 vote168 views1 answer
Drop check command
SQL