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

What is PL/SQL ?

2015

What is the difference between translate and replace?

1048

What is a subquery?

1103

How to declare a local variable?

1098

How to export data to a csv file?

1274

What are the different types of modules in oracle forms?

989

What is format trigger?

2057

What are the differences between lov and list item?

1045

How is it different from a normal table?

1009

What is merge statement used for?

1005

Explain the use of Merge statement in oracle 11g

1011

Explain coalesce function?

1177

What is oracle datasource?

964

does the query needs a hint to access a materialized view?

1845

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2024