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 / 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
Why use subqueries instead of joins?
What is a file delimiter?
Can two tables have same primary key?
What are different methods to trace the pl/sql code?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
How much does sql cost?
What is trigger types of trigger?
Why do we use joins in sql?
What is scope and visibility in PL/SQL?
How can we debug in PL/SQL?
Which data type is a composite type?
Why is sql better than hql?
how to delete an existing column in a table? : Sql dba
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
what are the different type of normalization? : Sql dba