将单列转换为多列-SQL Server [英] Convert single column in to multiple columns - SQL Server

问题描述

需要将单列转换为多列.
即2列或3列.

请帮忙做.

即从TableName中选择*会给出以下输出.
1
2
3
4
5
6

但是如果转换为两列，则应提供以下输出.
1,2
3,4
5,6

预先感谢.

Need to convert single column in to multiple columns.
i.e. 2 column or 3 column.

Please help to do this.

i.e. Select * from TableName gives following output.
1
2
3
4
5
6

but if you convert into two columns it should give following output.
1,2
3,4
5,6

Thanks in Advance.

推荐答案

您可以为此使用PIVOT.看看更多信息的链接:
http://www.sqldev.org/transactsql/create-multi-column-view-from-single-column-data-101597.shtml [

You can use PIVOT for that. Have a look at the link for more info:
http://www.sqldev.org/transactsql/create-multi-column-view-from-single-column-data-101597.shtml[^]

Good luck!

这篇关于将单列转换为多列-SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！