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 I order columns in sql?
how many ways we can we find the current date using mysql? : Sql dba
How many types of keys are there in sql?
What is an index in sql with example?
what are date and time functions in mysql? : Sql dba
What is the best sql course?
What steps server process has to take to execute an update statement?
How to create a menu in sqlplus or pl/sql?
What is range partitioning?
What is a temp table?
Do we need to rebuild index after truncate?
Enlist the data types that can be used in pl/sql?
Is sql free?
What is execution plan in sql?
Why do we need cursor in pl sql?