Listagg in Sqlserver

Elena Rostova
Elena Rostova
• • 3 min read

I'm Trying to Aggregate a 'String' Field in Sqlserver. I Would Like to Find the Same Function Listagg Like in Oracle. Do You Know How to Do the Same Function...

Listagg in Sqlserver

I'm trying to aggregate a 'STRING' field in SQLServer. I would like to find the same function LISTAGG like in Oracle .

Do you know how to do the same function or an another method?

For Example,

Field A | Field B
1       |  A
1       |  B
2       |  A

And I would like that the result of this query will be 

1 | AB
2 | A
1

4 Answers

Must Read

MySQL

SELECT FieldA
     , GROUP_CONCAT(FieldB ORDER BY FieldB SEPARATOR ',') AS FieldBs
  FROM TableName
 GROUP BY FieldA
 ORDER BY FieldA;
Elena Rostova

Elena Rostova

Lead Health, Wellness & Medical Journalist
Instagram Linkedin Twitter

Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.