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

How do I filter in sql profiler?

985

What is crud stand for?

984

How to get list of all tables from a database?

1138

Can we use loop in sql?

957

When you have to use a default "rollback to" savepoint of plvlog?

1170

Explain the uses of a database trigger?

1016

What is sql constant?

1008

what is top in tsql? : Transact sql

1086

what does it mean to have quoted_identifier on? : Sql dba

1130

What is the difference between drop and truncate commands?

1045

What are the 3 types of behavioral triggers?

1231

Which is better varchar or nvarchar?

976

How do you create a unique index?

1031

How much ram can sql express use?

964

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2001