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
5683 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

What is blob datatype?

1134

Where are the settings stored for each instance in oracle?

1111

What is oracle thin client?

1029

How to define a variable to match a table column data type?

994

What is query image?

985

is there a tool to trace queries, like profiler for sql server?

1147

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2271

What are the numeric comparison operations?

1125

How to create a temporary table in oracle?

1279

Explain do view contain data?

1018

Is primary key indexed by default in oracle?

994

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2037

What is flashback in Oracle?

1026

What is a cursor in oracle?

1186

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2243