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
- 5523 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
How do I start tns listener?
20. Using a set operator, display the client number of all clients who have never placed an order.
What are the differences between primary key and unique key?
How do we represent comments in oracle?
definition of cluster and non-clustered index?
How to display employee records who gets more salary than the average salary in the department?
What is an external table?
what is the use of system.effective.date variable in oracle?
What happens if recursive calls get out of control?
what are steps for interface? where is exchange rate defined in which table?
What is the usage of synonyms?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
State and explain the different types of data models?
How to convert csv to table in oracle?
How to omit columns with default values in insert statement in oracle?
