如何在行中显示列值 [英] How to show column value in row

问题描述

列值作为行
Col1 Col2
一个4
b 2
c 1
d 7

我想要结果为-
a b c d
4 2 1 7

Column value as Row
Col1 Col2
a 4
b 2
c 1
d 7

I want result in ,-
a b c d
4 2 1 7

推荐答案

有很多方法可以将Row转换为列，反之亦然.但是，最简单有效的方法是在SQL-服务器.


谢谢

There are many ways for converting Row to column or vice-versa.But the simplest and effective method is to use Pivot in SQL-server.


Thanks

您需要进行数据透视.

有关更多信息，请查看这些.
http://msdn.microsoft.com/en-us/library/ms177410％28v = sql.105％29.aspx [ ^ ]
http://blog.sqlauthority.com/2008/06 /07/sql-server-pivot-and-unpivot-table-examples/ [

You need to do pivoting.

For More info, please look at these.
http://msdn.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx[^]
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]

嗨..

使用数据透视表将帮助您找到答案


http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx [ http://msdn.microsoft.com/en-us/library/ms177410 (v = sql.105).aspx [ SQL-具有总计列和行总数的数据透视 [ ^ ]

Hi..

using pivot table will help you to find answer


http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx[^]

http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[^]

SQL - Pivot with Grand Total Column and Row[^]

这篇关于如何在行中显示列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！