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
- 5818 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 is a Schema ?
What is the use of aggregate functions in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the difference between SQL and SQL Server?
What is an index associated with a constraint?
How to define a cusotmer as a supplier in ORACLE R12
How to set up autotrace for a user account?
How to invoke the original export import utilities?
What is the data pump import utility?
query optmization techniques and quwry analyser+projects+ppts
Can we create more than one constraint to column ?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Oracle General 
