select sum(amount) amt , acname, actype from table group by acname , acty

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

Question Posted / amit kumar

2 Answers
5521 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

Please Help Members By Posting Answers For Below Questions

How to bring a tablespace online?

1080

What is system tablespace?

1100

What is a trigger oracle?

1092

What happens to the current transaction if the session is killed?

990

How to divide query output into groups in oracle?

992

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1843

What is a private synonym?

1591

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

How would you begin to troubleshoot an ORA-3113 error?

2080

How to manage transaction isolation level?

1006

What is a partition in oracle?

1122

Explain the use of grant option in exp command.

1067

Explain what are the uses of rollback segment?

1017

Explain temporal data types in oracle

1098

Can we commit inside a function in oracle?

967