sql server - How to use GROUP_CONCAT function on MSSQL

Question

How can I use the GROUP_CONCAT function on MSSQL while MySQL is running?

current table;
     QUESTION_ID    ANSWER_ID   USER
1.        1             1       A
2.        1             1       B
3.        1             2       C

i need;

     QUESTION_ID    ANSWER_ID   USER
1.        1             1       A, B
2.        1             2       C

thanks in advance..

Answer 1

The equivalent function could be STRING_AGG for SQL Server 2017 and later. Note that this function not support DISTINCT filtering.

select QUESTION_ID, ANSWER_ID, STRING_AGG(USER, ', ') as USER
from t1
group by QUESTION_ID, ANSWER_ID

https://docs.microsoft.com/en-gb/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-2017