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
What is procedure and function in sql?
what is the difference between primary key and unique key? : Sql dba
how to create a test table in your mysql server? : Sql dba
What is bulk collect in pl sql?
What is form and report?
Is sql developer case sensitive?
Does user triggers have entry for trigger with compilation errors?
How do you optimize a query?
What is lookup table in sql?
How to rename a table?
how to select unique records from a table? : Sql dba
What is the command used to fetch the first 5 characters of a string?
How to use transactions efficiently : transact sql
How can triggers be used for the table auditing?
What does closing a cursor do?