SQL Server How to combined String rows to one column

ippsafx7 于 2023-08-02 发布在其他

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

data A	data B
apple	apple, banana, cat
banana	apple, banana, cat
cat	apple, banana, cat

SELECT 
  data A,
  '' as data B
From tbl_test;

If I have data like Column data A and I want to combined this data to another column like data b

How can I query this one and show like I want

Sorry for my news sql

sql-server

来源：https://stackoverflow.com/questions/76658716/how-to-combined-string-rows-to-one-column

1条答案

按热度按时间

lb3vh1jj1#

By using STUFF we can combine all column data into single column by writing Subquery it will give's Result to all columns suitable for SQL Server 2014 . Code is as follows.

select dataA,STUFF((
select ','+r.dataA
from TestTable as r
for xml path('')),1,1,'') as dataB From TestTable

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server How to combined String rows to one column

1条答案

相关问题

热门标签

最新问答