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
- 5813 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
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is the Tune Query
Explain oracle’s system global area (sga).
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Explain an exception and its types?
When do I need to use a semicolon vs a slash in oracle sql?
what is the dual table in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Explain about integrity constraint?
Write a syntax for update query in oracle?
What is a oracle database?
How to export several tables together?
How to check the server version in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
what are the advantages of running a database in archive log mode?
