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   IBM, Loginworks, OFSS,

---

What is sql query optimization?

0 Answers  

---

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

---

What are the differences between implicit and explicit cursors?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

---

does sql support programming? : Sql dba

0 Answers  

---

What are the different types of functions in sql?

0 Answers  

---

What is natural join in sql?

0 Answers  

---

What is sql procedures and functions?

0 Answers  

---

How do I find duplicates in sql?

0 Answers  

---

What is foreign key in sql with example?

0 Answers  

---

what are the join types in tsql? : Transact sql

0 Answers  

---