如何将3行cancatenate到单行? [英] how to cancatenate 3 rows to single row?
本文介绍了如何将3行cancatenate到单行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有
列名列代码
jayaram BC1
jayaram BC2
jayaram BC65
jayaram BC66
我需要它
列名列代码
Jayaram BC1,BC2,BC65,BC56
解决方案
您是否搜索过Google?我得到了这个,定制它
将表中的行值转换为单个连接字符串 [ ^ ]
使用此查询并更好地了解it.refer solution1
选择的东西((选择 ' ,',+ cast(column_code as varchar )来自 table1 where column_name = ' Jayaram' for XML路径(' ')), 1 , 1 ,' 跨度>)
I'm having
Column Name Column Code
jayaram BC1
jayaram BC2
jayaram BC65
jayaram BC66
I need it as
Column name Column Code
Jayaram BC1,BC2,BC65,BC56
解决方案
Did you search Google for this? I got this, customize it
Converting row values in a table to a single concatenated string[^]
Use this Query and better you learn about it.refer solution1
select stuff((select ',',+cast(column_code as varchar) from table1 where column_name='Jayaram' for XML Path ('')),1,1,'')
这篇关于如何将3行cancatenate到单行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文