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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vinay
Select c1,sum(c2) over (order by c1) as C3 from T1
Is This Answer Correct ? | 13 Yes | 2 No |
Types of joins ?
When do we create bitmap indexes
How do you clear the screen in sql?
How to get second highest salary from a table
What is pl sql and why it is used for?
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
what is the difernece between named and anonymous pl/sql blocks??
Difference between views and materialized views?
How to access the current value and next value from a sequence?
how to shut down the server with 'mysqladmin'? : Sql dba
What are the two characteristics of a primary key?
in a package one procedure is wrong package shows valid or not