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
10625 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 are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

979

What is sql character function?

1052

What is lookup table in sql?

1019

What does bitemporal mean?

1048

What are triggers in sql?

1005

What is percent sign in sql?

1265

what is schema? : Sql dba

1026

what are properties of a transaction? : Sql dba

1076

What is the basic structure of an sql?

1078

what are null values? : Sql dba

937

Advantages and disadvantages of stored procedure?

1102

How do I run a sql script?

1121

how to include numeric values in sql statements? : Sql dba

1082

How many types of literals are available in pl sql?

1099

List the different type of joins?

1056