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 vote69 views1 answer
Check if due date is less than todays date sql
SQL
1 vote129 views1 answer
Tsql get beginning of year
SQL
1 vote114 views1 answer
Drop df constraint sql server
SQL
0 vote119 views1 answer
Sql DATE = GETDATE()
SQL
0 vote119 views1 answer
Postgres full text search example
SQL
0 vote114 views1 answer
Sql server pivot rows to columns
SQL
0 vote120 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote138 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
1 vote104 views1 answer
Sql insert for each distinct value
SQL
9 votes113 views4 answers
Last mysql
SQL