in account table account type amount ac1 credit 300 ac2 debit 50

in account table
account type amount
ac1 credit 300
ac2 debit 5000
ac3 credit 3000
ac1 debit 4000
ac3 debit 2000
ac2 credit 4000
write a query how to get sum of credit & sum of debit

Question Posted / gautam

3 Answers
4618 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit ..

Answer / vijay patil

-----------table lavel credit debit
select
sum(case when type=credit then isnull(amount,0)end)sum_credit,
sum(case when type=debit then isnull(amount,0) end)sum_debit
from account_table;

OR -----------table lavel credit debit

select type,sum(amount)amt
from account_table
group by type;

OR (at accont lavel credit debit)

select account,type,sum(amount)amt
from account_table
group by account,type;

Is This Answer Correct ?

8 Yes

0 No

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit ..

Answer / sanjay

select type,sum(amount)from account table group by type

Is This Answer Correct ?

3 Yes

0 No

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit ..

Answer / kamala k n

select type, sum(amount) over (partiton by sid) from tab

Is This Answer Correct ?

0 Yes

0 No

Post New Answer