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

Is it possible to update views?

961

Can we use update in sql function?

1066

what tools available for managing mysql server? : Sql dba

1088

How does stored procedure reduce network traffic?

1012

What is nvarchar in sql?

927

What is database white box testing and black box testing?

1112

Can we join more than 2 tables in sql?

1025

Can we enter data in a table in design view?

970

Where do we use pl sql?

1002

what is a composite key ? : Sql dba

1066

What is a procedure in pl sql?

1215

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1167

How does index help in query performance?

1031

What are different joins used in sql?

1058

What is transaction control language (tcl)?

1140