Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 5567 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / sanjay
select type,sum(amount)from account table group by type
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kamala k n
select type, sum(amount) over (partiton by sid) from tab
| Is This Answer Correct ? | 0 Yes | 0 No |
What happens if you use a wrong connect identifier?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
What are the differences between interval year to month and interval day to second?
How can Oracle users be audited?
how to get second highest sal of emp table
What is a cursor in oracle?
What is an external table?
Whats the benefit of dbms_stats over analyze?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
what is meant by magic query
What is the difference between sharding and replication?
Why does for update in oracle 8 cause an ora-01002 error?
Oracle General 
