Interested to Buy Any Domain ? << Click Here >> for more details...
acname actype amount
ac1 credit 300
ac2 credit 4000
ac1 debit 4000
ac2 debit 455
ac1 credit 500
how to get sum of credit and sum of debit for each account
- 2 Answers
- 5484 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / amit kumar
select sum(amount) amt , acname, actype from table group by
acname , actype
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How to use fetch statement in a loop?
Explain drop constraint oracle?
What is the difference between sharding and partitioning?
Explain how are indexes update?
What is a dynamic performance view in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is a cursor variable?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are the data types in oracle?
How to convert dates to characters in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Oracle
What is a snapshot in oracle database?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is java oracle used for?
