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

What is oracle instant client?

986

what is difference between sql plus and sql*plus? (not sql and sql plus).

3841

How to invoke the data pump export utility?

1137

How do I uninstall oracle client from windows?

978

how to join query for one source type is oracle another source type is sql server ?

2392

Explain about your project and its relation to the current job position you are applying to?

960

How to see free space of each tablespace?

986

ABOUT IDENTITY?

2017

How to select some columns from a table in oracle?

1023

How is it different from a normal table?

983

How to estimate disk space needed for an export job?

1007

how may join possible between (requisition with purchase order)

2185

How to handle a single quote in oracle sql?

990

How to find out what oracle odbc drivers are installed?

993

How to list all user accounts in oracle?

989