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

9 votes189 views1 answer
Oracle get table schema
SQL
4 votes173 views2 answers
Tsql utf to local time
SQL
0 vote188 views1 answer
Increase speed of like queries postgres
SQL
0 vote187 views1 answer
Sql stored procedure update if parameter is not null
SQL
3 votes171 views2 answers
To_char sql
SQL
0 vote181 views1 answer
C# add a textbox in mysql select
SQL
0 vote178 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote172 views1 answer
Json_remove mysql
SQL
7 votes175 views3 answers
How to check table name in current database sql
SQL
0 vote185 views1 answer
Ksql quickstart docker
SQL