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 vote153 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote146 views1 answer
Oracle current timestamp insert statement
SQL
0 vote154 views1 answer
Oracle table free space
SQL
9 votes175 views4 answers
Oracle get table column names
SQL
11 votes151 views3 answers
How to get last row of table in sql
SQL
5 votes142 views1 answer
JBDC
SQL
10 votes148 views1 answer
Oracle object dependencies
SQL
2 votes143 views1 answer
Drop table if exists in postgres
SQL
22 votes152 views3 answers
SQL CHEATSHEET
SQL
0 vote168 views2 answers
Drop tables from local table database postgres
SQL