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
10778 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 sql comments?

1119

Can I join the same table twice?

1095

What is a primary key? Explain

1024

What are the types of subqueries?

1102

What is date functions?

1091

What is java sql driver?

1183

Why left join is used in sql?

1019

Explain character-manipulation functions?

1176

What is a rank in sql?

1008

What is sql analyzer?

1059

What is the difference between partition and index?

1059

What if we write return in procedure?

1513

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2062

explain advantages of innodb over myisam. : Sql dba

1175

Can we update views in sql?

989