select type,sum(amount)from account table group by type

in account table
account type amount
ac1 credit 300
ac2 debit 5000
ac3 credit 3000
ac1 debit 4000
ac3 debit 2000
ac2 credit 4000
write a query how to get sum of credit & sum of debit

Question Posted / sanjay

3 Answers
5671 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / sanjay

select type,sum(amount)from account table group by type

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to call a stored function in oracle?

1018

can u plz provide me oca sql dumps please i need them

1947

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1113

How to invoke the data pump import utility?

1162

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2183

Can we convert a date to char in oracle and if so, what would be the syntax?

1014

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2104

What is where clause in oracle?

1025

How can windows applications connect to oracle servers?

1055

How can you merge two tables in oracle?

1001

How to rollback the current transaction in oracle?

1054

How to turn on or off recycle bin for the instance?

1083

What are the parameters that we can pass through a stored procedure?

1064

Why do we need integrity constraints in a database?

1018

Can we save images in a database and if yes, how?

1063