delete from emp e1 where rowid >(select min(rowid) from emp e2 where e

how to delete all duplicate records from a table using
subquery?

Question Posted / dharmendra

Answer Posted / dharmendra

delete from emp e1 where rowid >(select min(rowid) from emp
e2 where e1.empid=e2.empid)

Is This Answer Correct ?

12 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Why do we need integrity constraints in a database?

1072

Explain an integrity constrains?

1190

How to define a record variable to store a table row?

1106

What is an oracle tablespace?

1092

What is rowid and rownum in oracle?

1063

What is a table index in oracle?

1179

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

2252

In which language oracle has been developed?

1134

What is a initialization parameter file in oracle?

1079

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2365

Does facebook use oracle?

1078

What are the differences between number and binary_float in oracle?

1143

What would you do with an in-doubt distributed transaction?

2040

Explain the use of file option in exp command.

1171

How to connect to a local oracle 10g xe server?

1032