水平结果垂直（PIVOT） [英] Horizontal results to vertical (PIVOT)

问题描述

嗨伙计，

我有一个简单的查询，可以横向提供我的结果。

Hi dudes,
i've a simple query which gives me my results horizontally.

SELECT
 ROUND(SUM(TotalAmount),2) AS [Total Amount],
 ROUND(SUM(Amount1),2) AS [A],
 ROUND(SUM(Amount1),2) AS [B],
 ROUND(SUM(Amount1),2) AS [C],
 ROUND(SUM(Amount1),2) AS [D]

FROM tbl1

然后我有一行五列。

I then have one row and five columns.

Total Amount  A    B    C    D
   100       150  200  250  300  

如何才能我更改了查询，以便我得到两列。这样的事情：

How can i change the query so that i get two columns.Something like this:

Total Amount    100
 A              150
 B              200
 C              250
 D              300

推荐答案

尝试：

Try:

SELECT Value, V
FROM
(SELECT
 ROUND(SUM(TotalAmount),2) AS [Total Amount],
 ROUND(SUM(Amount1),2) AS [A],
 ROUND(SUM(Amount2),2) AS [B],
 ROUND(SUM(Amount3),2) AS [C],
 ROUND(SUM(Amount4),2) AS [D]

FROM tbl1 ) AS t
UNPIVOT
(
V FOR Value IN ([Total Amount], A, B, C, D)
) AS UP

这篇关于水平结果垂直（PIVOT）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！