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
- 10097 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
How do I sort a table in sql?
What is database migration?
Which command is used to delete a package?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What schema means?
explain normalization concept? : Sql dba
What are all the different normalization?
What is a pl/sql block?
discuss about myisam index statistics collection. : Sql dba
How do I create a sql script?
What is union and union all keyword in sql and what are their differences?
Can you load data into multiple tables at once? : aql loader
What is native sql query?
how can we know the count/number of elements of an array? : Sql dba
Where the sql database files are stored?
