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
- 5626 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / sanjay
select type,sum(amount)from account table group by type
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain the use of log option in exp command.
How to select some rows from a table in oracle?
What are advantages of dateset in datastage?
What are internal user account in oracle?
Why do we use bulk collect in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How do we get field details of a table?
Explain mutating triggers.
What privilege is needed for a user to query tables in another schema?
Explain the importance of .pll extension in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is an oracle user role?
Why does for update in oracle 8 cause an ora-01002 error?
What are the different types of modules in oracle forms?
What is the data pump export utility?
