acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit

acname actype amount
ac1 credit 300
ac2 credit 4000
ac1 debit 4000
ac2 debit 455
ac1 credit 500
how to get sum of credit and sum of debit for each account

Question Posted / gau

2 Answers
4436 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit ..

Answer / terence

select
acname,
sum(decode(actype,'credit',amount,0)) Credit,
sum(decode(actype,'debit',amount,0)) Debit
from account_table
group by acname

Is This Answer Correct ?

11 Yes

1 No

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit ..

Answer / amit kumar

select sum(amount) amt , acname, actype from table group by
acname , actype

Is This Answer Correct ?

6 Yes

2 No

Post New Answer