select type, sum(amount) over (partiton by sid) from tab

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 / kamala k n

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

Answer Posted / kamala k n

select type, sum(amount) over (partiton by sid) from tab

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to use fetch statement in a loop?

970

What is oracle and what are its different editions?

1007

How to use existing values in update statements using oracle?

1009

How to write an inner join with the where clause in oracle?

991

What is the usage of merge statement?

1094

Explain the features of oracle?

987

What is an index associated with a constraint?

973

Where do we use decode and case statements?

942

What is partitioned table in Oracle?

1102

How to resolve name conflicts between variables and columns?

977

What is the difference between PFILE and SPFILE in Oracle?

993

What are privileges and grants?

1001

How view is different from a table?

966

How to drop an existing view in oracle?

902

How to write date and time literals in oracle?

944