Select c1,sum(c2) over (order by c1) as C3 from T1

i have a table like this. i want to output like this
c1 c2 c1 c2

1 10 1 10
2 20 2 30
3 30 3 60
4 40 4 100
5 5 5 105

c1 and c2 are columns in a table .i want output like this

c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5.

write a sql query.pls help this
i want urgent.

Question Posted / vinay

2 Answers
10668 Views
IBM, Loginworks, OFSS, I also Faced
E-Mail Answers

Answer Posted / vinay

Select c1,sum(c2) over (order by c1) as C3 from T1

Is This Answer Correct ?

13 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do stored procedures prevent sql injection?

971

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2284

What is Histogram?

1564

How do we accept inputs from user during runtime?

1071

When are we going to use truncate and delete?

991

Enlist the advantages of sql.

1006

how do you tune the slow running queries in oracle db , explain the methodology

2823

Which is faster union or join?

977

what is the difference between truncate and drop statements? : Sql dba

1133

What is replication id?

941

What trigger means?

997

what is online transaction processing (oltp)? : Sql dba

999

What is rollback?

1118

What are the triggers associated with image items?

1043

How do I remove sql plus from windows 10?

1106