oracle資料庫表 ccs_order
count（銷量）
id name count cash date
1 諾基亞 1 3792 2017/03/20 11:07:47
2 諾基亞 1 3792 2017/03/1711:07:49
3 諾基亞 1 3792 2017/03/19 11:07:50
4 諾基亞 1 3792 2017/03/18 11:07:52
5 戴爾 1 7570 2017/03/18 14:52:23
6 戴爾 1 5613 2017/03/17 14:52:24
uj5u.com熱心網友回復：
起碼給個期待結果啊，寫全一些uj5u.com熱心網友回復：
select
sum(to_char(date,'ww') = '11' then count end) "上周銷量",
sum(to_char(date,'ww') = '12' then count end) "本周銷量",
sum(to_char(date,'yyyy') = '2017' then count end) "本年銷量",
(sum(to_char(date,'ww') = '12' then count end)-sum(to_char(date,'ww') = '11' then count end))/sum(to_char(date,'ww') = '11' then count end) "周上升幅度"
from ccs_order;
uj5u.com熱心網友回復：
這個陳述句不太好查了3次表select 上周銷量,
本周銷量,
本年銷量,
(本周銷量 - 上周銷量) / 上周銷量 周上升幅度
from (select (select sum(count)
from ccs_order
where date >= trunc(sysdate, 'd') - 6
and date < trunc(sysdate, 'd') + 1) 上周銷量,
(select sum(co unt)
from ccs_order
where date >= trunc(sysdate, 'd') + 1
and date < trunc(sysdate, 'd') + 8) 本周銷量,
(select sum(count)
from ccs_order
where date >= trunc(sysdate, 'YYYY')) 本年銷量,
from dual)
uj5u.com熱心網友回復：
select
sum(case when to_char(date,'ww') = '11' then count end) "上周銷量",
sum(case when to_char(date,'ww') = '12' then count end) "本周銷量",
sum(case when to_char(date,'yyyy') = '2017' then count end) "本年銷量",
(sum(case when to_char(date,'ww') = '12' then count end)-sum(case when to_char(date,'ww') = '11' then count end))/sum(case when to_char(date,'ww') = '11' then count end) "周上升幅度"
from ccs_order;
2樓忘記加case when 了 。。。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/100776.html
標籤：開發
下一篇：求助大神，新手