Answer Posted / lingareddy

by using below sub query delete duplicate all records:

DELETE FROM dept WHERE salary IN (
SELECT salary FROM dept GROUP BY salary HAVING ( COUNT(salary) > 1 ))


here is dept is the table name
salary is the column name

for any doubts about SQL contact with me

Thanks & Regards
Lingareddy.S

What is a read write transaction in oracle?

1093

---

How to define an oracle sub procedure?

1146

---

How to convert a string to a date in oracle database?

1054

---

How to write numeric literals in oracle?

1185

---

What is a database table in oracle?

1023

---

State any two functions of oracle?

1046

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1900

---

how to make an oracle object

2360

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2234

---

Is oracle a language?

948

---

Explain temporal data types in oracle

1096

---

How to run the anonymous block again?

1132

---

How to use "out" parameter properly?

1082

---

What are the arithmetic operations?

1084

---

How to count duplicated values in a column in oracle?

1044

---