How to concatenate values from a column grouping by a specific values from another column using TSQL?

Question

I would like to concatenate the follow columns X, Y and Z, grouping by ProductToday and separating the values with comma " , " from my TSQL table.

As a result I would like to have it:

Which query should I use to to it ?

P.S: some values from columns X,Y,Z are also Null.

Does this answer your question? [How to use GROUP BY to concatenate strings in MySQL?](https://stackoverflow.com/questions/149772/how-to-use-group-by-to-concatenate-strings-in-mysql) — NajiMakhoul, Jan 24 '22 at 15:18
I'm guessing since this says TSQL that this is sql-server, not mysql; retagging — ysth, Jan 24 '22 at 18:28

score 1 · Answer 1 · answered Jan 25 '22 at 05:30

1

You can use STRING_AGG() in sql server and GROUP_CONCAT in MySQL

For SQL Server:

SELECT 
    STRING_AGG(Z,',')
FROM 
    yourTable
GROUP BY ProductToday

For MySQL:

SELECT GROUP_CONCAT(Z SEPARATOR ',') FROM yourTable GROUP BY ProductToday;

answered Jan 25 '22 at 05:30

Bilal Bin Zia

1 Answers1