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.
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
how do you control the max size of a heap table? : Sql dba
What are stuff and replace function?
What are the different dml commands in sql?
What is union and union all keyword in sql?
What is aggregate function in sql?
How do you write a complex sql query?
What is the difference between inner join and natural join?
What is procedure in pl sql?
What are inbuilt functions in sql?
How do you update a table in sql?
How much does sql cost?
What is left join in postgresql?
Does truncate release storage space?
What are the types of variables use in pl sql?
How do we use distinct statement? What is its use?