Group_concat sql server

How to use group_concat in sql server

SELECT STRING_AGG(column_name, ',') AS Result
FROM table_name

Source: database.guide

Group_concat in mysql

GROUP_CONCAT(eng_category_name SEPARATOR ',') as eng_category_name

Group_concat sql server

STRING_AGG ( expression, separator ) [ <order_clause> ]

<order_clause> ::=   
    WITHIN GROUP ( ORDER BY <order_by_expression_list> [ ASC | DESC ] )
    SELECT STRING_AGG(Genre, ',') AS Result
FROM Genres;
Result:

Result                                      
--------------------------------------------
Rock,Jazz,Country,Pop,Blues,Hip Hop,Rap,Punk

Source: database.guide

Similar codes

1 vote273 views1 answer
Psql show with user is logged in
SQL
0 vote279 views1 answer
Postgresql parse json array
SQL
3 votes305 views1 answer
Force using index oracle
SQL
1 vote291 views1 answer
Mysql pretty date format
SQL
-2 votes321 views4 answers
How to get max salary in each department in sql
SQL
6 votes379 views3 answers
What is where in sql
SQL
4 votes324 views1 answer
Postgresql list sequences
SQL
0 vote283 views0 answer
SQL
0 vote318 views1 answer
Call scalar valued function sql
SQL
3 votes304 views1 answer
Sql timestamp to date
SQL