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

2 votes310 views1 answer
Postgresql update sequence next value
SQL
0 vote288 views1 answer
Sql server count all tables rows
SQL
1 vote332 views1 answer
Mysql find most common value
SQL
0 vote357 views1 answer
Mysl like insert a variable
SQL
0 vote293 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote298 views2 answers
Search stored procedures by name
SQL
2 votes302 views1 answer
Oracle run_duration average
SQL
0 vote581 views1 answer
How to connect .sql data set to powerbi
SQL
3 votes304 views1 answer
Uppercase and lowercase in sql
SQL
4 votes290 views4 answers
Sqlite describe table
SQL