How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

Does group by remove duplicates?

0 Answers  

---

What is meant by cursor in sql?

0 Answers  

---

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

---

---

What are the different types of joins in sql?

0 Answers  

---

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

23 Answers   IBM,

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

---

Which certification is best for sql?

0 Answers  

---

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

---

Explain the uses of database trigger.

0 Answers  

---

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,

---