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
10540 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 sql free?

887

What is string data type in sql?

1050

Enlist the advantages of sql.

937

What are all the common sql functions?

969

How to find 3rd highest salary of an employee from the employee table in sql?

1035

Does execute immediate commit?

1152

Can we update views in sql?

897

What is pivot table in sql?

1017

What is the difference between pl and sql?

1035

Can %notfound return null after a fetch?

1000

Explain the advantages and disadvantages of stored procedure?

1076

What are the most important characteristics of pl/sql?

1078

What is the difference between a primary key and a unique key?

998

What are the types of records?

951

What is the difference among union, minus and intersect?

949