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 vote125 views1 answer
Sql server list locks
SQL
1 vote115 views1 answer
Woocommerce mysql price table
SQL
0 vote116 views1 answer
With_for_update sqlalchemy
SQL
0 vote122 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote122 views1 answer
Joomla execute raw sql
SQL
0 vote157 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote144 views1 answer
SQL Where-Klausel
SQL
17 votes113 views6 answers
Mysql import sql file
SQL
0 vote121 views1 answer
Apt install sql server
SQL
0 vote109 views1 answer
Opensuse stop MySQL
SQL