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
10654 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 to shut down the server with 'mysqladmin'? : Sql dba

1012

What is thread join () in threading?

1015

what is the bond code in materialized view?

3002

What is the mutating table and constraining table?

1026

what are numeric data types? : Sql dba

1060

What are different categories of sql commands?

1133

Mention what is the plv (pl/vision) package offers?

1107

What are tables in sql?

1065

What are pl/sql cursor exceptions?

1103

What is the cause of mutating table error and how can we solve it?

1049

How do I count rows in sql query?

988

define sql delete statement ? : Sql dba

1018

What port does sql server use?

1061

What is a system versioned table?

986

What is rank () in sql?

941