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

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2155

---

What is SQL access advisor in Oracle?

1149

---

How do I reset a sequence in oracle?

1062

---

Why we use bulk collect in oracle?

983

---

How to assign a tablespace to a users in oracle?

1006

---

what are the advantages of running a database in archive log mode?

2151

---

What is oracle database 10g express edition?

1080

---

What are the execution control statements?

1022

---

How can Oracle users be audited?

1066

---

Explain index?

1213

---

how to make an oracle object

2305

---

Explain how are indexes update?

1030

---

How many types of table in Oracle?

1075

---

Explain about the analyze command in oracle?

1008

---

Compare and contrast between sql and sql server and explain its various functions?

927

---