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
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
What do you mean by cdb and pdb in oracle 12c?
How to connect to the server with user account: sys?
What are dml statements in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Explain how are indexes update?
How to define an external table with a text file?
What happens if you set the sga too low in oracle?
How oracle handles dead locks?
What is query image?
What is java oracle used for?
Differentiate between function and procedure in oracle.
What is Java Pool in Oracle?
How to pass a parameter to a cursor in oracle?
How to execute the package in oracle?
Explain the use of inctype option in exp command.