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,

---

How does left join work in sql?

0 Answers  

---

How do you create a db file?

0 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

What is the difference between microsoft access and sql?

0 Answers  

---

What is record variable?

0 Answers  

---

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

Explain two easy sql optimizations.

0 Answers  

---

What is pl sql in oracle?

0 Answers  

---