select t.c1, (SELECT SUM(x.c2) FROM table

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 / prativa mishra

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

Answer Posted / prativa mishra

select t.c1,
(SELECT SUM(x.c2)
FROM table_name x
where x.c1 <= t.c1) as c2
from new table_name

or

select c1,
SUM(SUM(c2)) OVER
(ORDER BY c1 ROWS BETWEEN UNBOUNDED PRECEDING AND
CURRENT ROW)
AS C2
from table_name
group by c1

Is This Answer Correct ?

17 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the purpose of the primary key?

1117

how to fetch common records from two tables? : Sql dba

1251

When sql appeared?

1148

What is a primary key? Explain

1025

what are the type of locks ? : Sql dba

1010

what is transaction? : Sql dba

1061

Is sql an operating system?

1075

What is case function?

1092

How do you concatenate in sql?

1086

What is foreign key in sql with example?

975

How do you modify a table in sql?

1165

How do I view a procedure in sql?

1019

What is rank function in sql?

1071

Why join is faster than subquery?

1161

what are the advantages of mysql in comparison to oracle? : Sql dba

1048