请问各位大神以下oracle plsql语句怎么写
发布网友
发布时间:2022-04-09 12:07
我来回答
共1个回答
热心网友
时间:2022-04-09 13:36
select
c.ckmc
仓库名称,
t.合计,
t.物品A,
t.物品B,
t.物品C,
t.物品D,
t.物品E
from
ckdm
c,
(select
a.ckdm,
sum(decode(a.hpdm,
301,
a.je))
+
sum(decode(a.hpdm,
302,
a.je))
+
sum(decode(a.hpdm,
303,
a.je))
+
sum(decode(a.hpdm,
304,
a.je))
+
sum(decode(a.hpdm,
305,
a.je))
合计,
sum(decode(a.hpdm,
301,
a.je))
物品A,
sum(decode(a.hpdm,
302,
a.je))
物品B,
sum(decode(a.hpdm,
303,
a.je))
物品C,
sum(decode(a.hpdm,
304,
a.je))
物品D,
sum(decode(a.hpdm,
305,
a.je))
物品E,
from
ckhp
a
group
by
a.ckdm)
t
where
t.ckdm
=
c.ckdm
group
by
ckmc
order
by
c.ckdm;
没有实际建表,你试下是否可行。