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
In the oracle version 9.3.0.5.0, what does each number shows?
How to export data with a field delimiter?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is raw datatype in oracle?
How to add a new column to an existing table with a default value?
How to establish administrator authentication to the server?
What is the max number of columns in an oracle table?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What are the oracle differences between nvl and coalesce
what is port in oracle? how is it related to database application.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is a database table in oracle?
How to experiment a data lock in oracle?
Explain an exception?
Why do you use stored procedures and state some of its disadvantages?