有一张表A
结构:
NAME QTY KEY
____________________________________________________________
A 2 1
B 3 2
A 4 3
A 6 4
_______________________________________________________________
现在我想合计Name = 'A' 的 QTY
但是有条件当key = 1 or key = 2 时
qty = (-1)*qty
如何一次合计出所有数量,请指教
结构:
NAME QTY KEY
____________________________________________________________
A 2 1
B 3 2
A 4 3
A 6 4
_______________________________________________________________
现在我想合计Name = 'A' 的 QTY
但是有条件当key = 1 or key = 2 时
qty = (-1)*qty
如何一次合计出所有数量,请指教
sum(decode(key,1,-1*qty,2,-1*qty,qty))
from table
where Name='A'
group by name
sum(case when key = 1 or key = 2 then - Qty else Qty end )
from table
where Name='A'
group by name