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
5613 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 define a sub function?

1206

What is bind variable in oracle 11g?

1097

How to convert times to characters in oracle?

1078

How to create lov dynamically at runtime & attach to text field?

1240

What is a trigger and what are its types in oracle?

1157

How to assign query results to variables?

1098

what is dynamic SGA and static SGA

4493

What is a cursor in oracle?

1232

How to apply filtering criteria at group level in oracle?

1091

How to update a table row with a record?

1069

What are the various oracle database objects?

1204

Is java required for oracle client?

1049

What is rich query?

1039

Explain the features of oracle?

1112

What is a database schema in oracle?

1157