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

How to establish administrator authentication to the server?

982

How to speed up webrick?

1006

Explain about the analyze command in oracle?

996

How do we get field detail of a table?

1020

How to use select statement to count the number of rows in oracle?

986

What is translate in oracle?

1049

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1031

How to execute a stored procedure in oracle?

1028

How to use in conditions in oracle?

995

what are steps for interface? where is exchange rate defined in which table?

2055

How to create a server parameter file?

1080

How does one get the view definition of fixed views/tables?

967

What are group functions in oracle?

973

What privilege is needed for a user to create views in oracle?

979

How to increment dates by 1 in oracle?

990