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.
- 2 Answers
- 9686 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
What is sql stand for?
What is PL/SQL Records?
how can we know the number of days between two given dates using mysql? : Sql dba
What are the parts of a sql statement?
What is sql entity?
Is it mandatory for the primary key to be given a value when a new record is inserted?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What view means?
How can you get sql*loader to commit only at the end of the load file? : aql loader
what are the properties and different types of sub-queries? : Sql dba
What is sharding in sql?
What are the types of views in sql?
what is foreign key? : Sql dba
what is a database? : Sql dba
What are the different types of joins in sql?
