how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

How do you delete duplicates in sql query using rowid?

0 Answers  

---

What is pl/sql table? Why it is used?

0 Answers  

---

How do you add a column to a table?

0 Answers  

---

---

How to set up sql*plus output format in oracle?

0 Answers  

---

How to run sql statements through the web interface?

0 Answers  

---

What does select * from mean in sql?

0 Answers  

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

Explain alias in sql?

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

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 in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---