Abhishek Gupta

• Mar 16th, 2006

 

yes you can delete the duplicate records with the help of a sql query as follows

delete from table_name where rowid not in(select max(rowid) from table_name group by field_name)

in this way only rowid with distinct values will remain and the rest will be removed.I hope it will help you out.

Anjali

• Aug 23rd, 2006

 

Abhishek, I think in the group by clause u need to add all the field names, so as to make sure the records are exactly same.

Anjali

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

 

use this query:

delete from emp e

where rowid <> ( select max(rowid) from  emp

where ename = e.ename );