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
5606 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 get a list of all user accounts in the database?

1129

How to update values in a table in oracle?

1077

What is proxy method?

1020

What are the set operators union, union all, minus & intersect meant to do?

1027

What are the various oracle database objects?

1201

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1395

Differentiate between translate and replace?

1186

How to define a procedure inside another procedure?

1066

What is oracle and what are its different editions?

1118

How do you find current date and time in oracle?

1099

What is an oracle and why it is used?

1212

What are dml statements in oracle?

1130

definition of cluster and non-clustered index?

3100

What do you mean by cdb and pdb in oracle 12c?

1101

Differentiate between post-database commit and post-form commit?

1092