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

104 votes1.1K views2 answers
Like in mysql
SQL
1 vote186 views1 answer
Oracle insert multiple rows into same table
SQL
1 vote206 views2 answers
Install sql server management studio ubuntu
SQL
13 votes178 views1 answer
Views in sql
SQL
1 vote162 views1 answer
How to use a trigger to validate input data
SQL
0 vote168 views1 answer
Mysql record group by created date count
SQL
0 vote196 views1 answer
Get created time of database psql 8
SQL
0 vote193 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
5 votes230 views1 answer
How to get all table names in sql query
SQL
0 vote176 views1 answer
Postgresql not in alternative
SQL