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
- 10101 Views
- IBM, Loginworks, OFSS, I also Faced
- E-Mail Answers
Answer Posted / vinay
Select c1,sum(c2) over (order by c1) as C3 from T1
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Can we use delete in merge statement?
Does access use sql?
Can ddl statements be used in pl/sql?
What found sql?
What is the purpose of the partition table?
How is a PL/SQL code compiled?
What is implicit cursor in pl sql?
Why is pl sql needed?
how mysql optimizes distinct? : Sql dba
How would you convert date into julian date format?
Is full outer join same as cross join?
what is oltp (online transaction processing)? : Sql dba
define join and explain different type of joins? : Sql dba
What is synonyms?
What is an inconsistent dependency?
