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 would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1916

How do I find my oracle client driver version?

1046

Is there a function to split a string in plsql?

1068

How to use subqueries with the in operator using oracle?

1093

What is an oracle and why it is used?

1154

How to sort output in descending order in oracle?

1049

What is MTTR advisor in Oracle?

1091

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2210

What is an oracle database?

1048

How to create tables for odbc connection testing?

1124

Difference between varchar and varchar2 data types?

1189

What are the original export and import utilities?

1177

How to check the oracle tns settings?

1048

What happens if you lost a data file?

1038

Explain the use of record option in exp command.

1007