SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Output using decode

529970Aug 25 2006 — edited Aug 25 2006

I have one table tran. Where i store daily transaction in it.
Structure of Table
Acno Number,
Type Char(1),
Amt Number(14,2)

Following is the date in table
Acno Type Amt
101 D 500.00
102 C 2500.00
101 C 1000.00
102 D 500.00
101 C 5000.00

I want to know the turnover of account using decode.
Output should be as following
Acno Turnover
101 5500.00
102 2000.00

Pls give me the solution using decode
Thanks & regards,
Rahul Gaikwad

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2006

Added on Aug 25 2006

5 comments

307 views