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 oracle use sql?

0 Answers  

---

How do we use distinct statement? What is its use?

0 Answers  

---

What are the two types of exceptions in pl/sql?

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

---

Do we need commit after truncate?

0 Answers  

---

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

How do you rename a table in sql?

0 Answers  

---

in a package one procedure is wrong package shows valid or not

4 Answers  

---

What is the difference between an inner and outer join?

0 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---