-1

I have a table called SOURCE_CATEGORY with SOURCEID and NAME. I have 4020 and 4025, how is it possible to combine the NAME field based on the SOURCEID using SQL Query?

enter image description here

I am hoping to get this result, because I wanted to copy the data in MSSQL to MongoDB which can combine the result into array. I only wanted the NAME field in mongodb. Is it possible to custom the SQL in MSSQL to kind of group them?

enter image description here

xxestter
  • 441
  • 7
  • 19
  • Please can you edit your question and add your simple data and query as text not images so it can be easy for us to help you – SelVazi Apr 25 '23 at 09:20
  • [Please do not upload images of code/data/errors when asking a question.](//meta.stackoverflow.com/q/285551) – Thom A Apr 25 '23 at 09:20

1 Answers1

1

You can do it using string_agg as follows :

select sourceid, string_agg( experience, ',') AS NAME
from source_category
group by sourceid
order by sourceid
SelVazi
  • 10,028
  • 2
  • 13
  • 29