SQl查询列到行视图 [英] SQl query for column to row View

问题描述

您好b $ b

我有两列（月，金额）。我输入了今年的数据。我需要按行显示它。我向你展示如下格式。我不知道如何构建SQL查询。



表：

月份金额

jan 500
feb 510

等..



i希望显示如下

jan feb is作为标题。

jan feb

500 510

Hi
I have two columns(month,amount). i had enter the datas of the year. i need to show it in row wise. i show u the format like below. i dont know how to construct sql query.

table:
month Amount
jan 500
feb 510
etc..

i want to display like this
jan feb is act as header.
jan feb
500 510

推荐答案

SELECT * FROM tablename
PIVOT
(
  sum(amount) FOR month IN ([jan],[feb])
)AS somename

是的，你可以使用数据透视或案例条件

Yes you can using pivot or case condition

SELECT SUM(A.JAN)AS JAN,SUM(A.FEB)AS FEB
FROM (
SELECT CASE WHEN [month]='jan' THEN amount ELSE 0 END AS JAN,
CASE WHEN [month]='feb' THEN amount ELSE 0 END AS FEB
FROM dbo.tbl1)AS A

只是要添加，我写了一篇文章，解释了所有可能的方法，以及它们如何工作： SQL Wiza rdry Part Seven - PIVOT和任意数据列表 [ ^ ]

Just to add, I've written an article that explains all the possible ways to do this, and how they work: SQL Wizardry Part Seven - PIVOT and arbitrary lists of data[^]

这篇关于SQl查询列到行视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！