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

4 votes129 views1 answer
Oracle session date format
SQL
2 votes146 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote134 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote138 views1 answer
Sql count * vs count 1
SQL
1 vote134 views2 answers
Install mysqldump ubuntu
SQL
8 votes149 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote136 views1 answer
Assign value to var in SQL
SQL
0 vote139 views1 answer
How to set all the min and sec data to zero in sql server
SQL
2 votes135 views1 answer
Mysql query unique column
SQL
50 votes240 views6 answers
Sql count duplicate rows
SQL