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

What is a dynamic query?

973

how to create a new table by selecting rows from another table in mysql? : Sql dba

1011

What is a data manipulation language?

966

Why we use pl sql?

908

What is the difference between inner join and natural join?

956

Can we join same table in sql?

964

What type of database is sql?

979

explain the difference between bool, tinyint and bit. : Sql dba

939

What is trigger price?

926

Is there any restriction on the use of union in embedded sql?

1103

What are some predefined exceptions in pl/sql?

1066

How do I add a database to sql?

1064

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3010

what is index? : Sql dba

945

Explain mutating table error.

1131