本文介绍了oracle中的动态数据透视(在子句中)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这样的数据
I have a data like this
TYPE RANGE SALES
A 20180301-20180101 100
A 20171201-20171031 150
A 20170930-20170731 100
B 20180301-20180101 200
B 20171201- 20171031 200
i想要这样的输出
i want output like this
TYPE 20180301-20180101 20171201-20171031 20170930-20170731
A 100 150 100
我的尝试:
这就是我的尝试
What I have tried:
This is what I have tried
SELECT
FROM
(
SELECT TYPE,MONTH_RANGE,SALES
FROM TABLE
)
pivot
(
SUM(SALES)
FOR (MONTH_RANGE) IN (SELECT DISTINCT MONTH_RANGE FROM TABLE)
)
我也尝试使用XML,但它的格式不正确
And I tried with XML as well, but its not in a proper format
pivot xml (SUM(SALES) for (month_range) in (SELECT DISTINCT MONTH_RANGE FROM TABLE))
我希望这个月的范围是动态的,不像
I want this month range to be dynamic not like
for month_range in ('20180301-20180101')
推荐答案
这篇关于oracle中的动态数据透视(在子句中)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!