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
5811 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 do we get field details of a table?

1027

How to write date and time interval literals in oracle?

1079

Is there a function to split a string in plsql?

1109

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2387

What are the benefits of ordbms?

1136

How to connect ms access to oracle servers?

1056

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

What are the advantages of oracle 12c?

1234

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2118

What is an oracle function?

1241

Explain table?

1176

What is a table index?

1167

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2522

Explain the truncate in oracle?

1011

How to establish administrator authentication to the server?

1095