anuj12paritosh (12/19/2012)

---

hi All ,

I have a table and columns with data is mention below :-

Table :- ORDER

COLUMN and values :-

ROWNUM ORDERID BALANCEQUANTITY
1 19 5
2 92 5

i want to deduct balance quantity 8 with sum of both rows
so how can we deduct from same

after deduction the result will be :-

ROWNUM ORDERID BALANCEQUANTITY
1 19 0
2 92 2

Thanks in advance.