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 run queries on external tables?

1033

Explain what are the characteristics of data files?

1077

Can group functions be used in the order by clause in oracle?

990

What is oracle instant client?

1018

master table and child table performances and comparisons in Oracle ?

2130

What is a read write transaction in oracle?

1078

What is a snapshot log?

994

How to drop a stored function?

1133

How to resolve name conflicts between variables and columns?

1017

How to update values on multiple rows in oracle?

1027

What is oracle update statement with inner join ?

1046

What do you understand by database schema and what does it hold?

1228

How can you merge two tables in oracle?

989

Can you tell me how to add new column in existing views?how?How is possible?

1431

How to upsert (update or insert into a table)?

993