SQL Server Comma separated values in a column in SQL

bnl4lu3b 于 2023-05-05 发布在其他

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

I am using Microsoft SQL server. I have a select statement that has number of columns queried from joining more than 4 tables, and the result table is shown as below,
| column1 | column2 | column3 | column4 |
| ------------ | ------------ | ------------ | ------------ |
| 1 | File1 | Table1 | Column1 |
| 1 | File1 | Table1 | Column2 |
| 1 | File1 | Table2 | Column1 |

Here, the values of Column4 are distinct that must be grouped and the result that I require is,

column1	column2	column3	column4
1	File1	Table1	Column1, Column2
1	File2	Table2	Column1

sql-server

来源：https://stackoverflow.com/questions/76181892/comma-separated-values-in-a-column-in-sql

1条答案

按热度按时间

91zkwejq1#

you can use STRING_AGG

select column1,column2,column3,STRING_AGG(column4,',') as column4
from adds
group by column1,column2,column3

base Data

create table adds(
column1 varchar(100),   column2 varchar(100),   column3 varchar(100),   column4 varchar(100)
)
insert into adds values
(1, 'File1',    'Table1'    ,'Column1')
,(1,'File1',    'Table1'    ,'Column2')
,(1,'File1',    'Table2'    ,'Column1')

赞(0）回复(0）举报 2023-05-05

我来回答

SQL Server Comma separated values in a column in SQL

1条答案

相关问题

热门标签

最新问答