SQL Server SQL Query to group the values based on the key column [duplicate]

qfe3c7zg 于 2023-04-28 发布在其他

关注(0)|答案(1)|浏览(156)

This question already has answers here:

Comma separated results in SQL (5 answers)
Closed 3 days ago.

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?

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?

sql-server

来源：https://stackoverflow.com/questions/76099499/sql-query-to-group-the-values-based-on-the-key-column

1条答案

按热度按时间

zpgglvta1#

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

赞(0）回复(0）举报 2023-04-28

我来回答

SQL Server SQL Query to group the values based on the key column [duplicate]

1条答案

相关问题

热门标签

最新问答