uj5u.com熱心網友回復：
select br.branch_name, sum(so.order_price) total
from sellorders so, storehouse sh, branch br
where so.store_id = sh.store_id
and sh.branch_id = br.branch_id
so.delivery_state = 15
and so.order_time >= to_date('20150301', 'YYYYMMDD')
and so.order_time < to_date('20150401', 'YYYYMMDD')
and so.order_price > 500
group by br.branch_name;
uj5u.com熱心網友回復：
sum(so.order_price/10000) totaluj5u.com熱心網友回復：
sum(so.order_price)/10000 totaluj5u.com熱心網友回復：
SELECT a.branch_id,round(SUM(c.order_price)/10000,2)FROM branch a,storehouse b,sellorders c
WHERE a.branch_id = b.branch_id
AND b.store_id = c.store_id
AND c.order_time >= to_date('20150301','yyyymmdd')
AND c.order_time < to_date('20150401','yyyymmdd')
AND c.delivery_state=15
AND c.order_price>500
GROUP BY a.branch_id
--大概就這樣
uj5u.com熱心網友回復：
1個倉庫有兩個分公司共用的話、那你怎么確定這個倉庫的訂單金額是哪個公司的、訂單表里應該少一個分公司id欄位吧select c.branch_name,concat(round(a.total/10000,2),'萬') from
(select store_id,sum(order_price)as total from sellorders
where delivery_state = 15
and to_char(order_time,'yyyy-mm')='2015-03'
group by store_id
having sum(order_price)>500)a
inner join storehouse b
on a.store_id=b.store_id
left join branch c
on b.branch_id=c.branch_id
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/70805.html
標籤：基礎和管理
上一篇：路過的大佬幫忙看下關于 多個 decode 效率問題，
下一篇：求SQL改造陳述句