venkata satya arun kumar

• May 10th, 2007

 

It is possible to delete duplicate records from table without using rowid.
First way is that if you have not used primary key use primary key which wont allow duplicate rows.

deep_pinu

 Profile Answers by deep_pinu 

• Mar 10th, 2008

 

it is pretty easy to delete dublicate rows using UNIQUE index on the table...the column on which you can find out duplicacy of records.

Alter table xyz add unique index (col1,col2,...)

on executing the query Duplicate keys are automatically deleted from the databse.
:) enjoy...

avanibhatt2006

 Profile Answers by avanibhatt2006 Questions by avanibhatt2006

• Feb 10th, 2009

 

delete from myTable where (field1, field2) not in ( select distinct(field1), field2
from myTable);

duttasujata

 Profile Answers by duttasujata 

• Oct 21st, 2010

 

Delete T1 from tablename as T1, tablename as T2 where T1.name=T2.name and T1.id>T2.id

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

Yes it is possible.Please check following syntax:

delete from table1
USING table1, table1 as vtable
WHERE (NOT table1.ID=vtable.ID)
AND (table1.field_name=vtable.field_name)

In above place column name in place of field_name to check duplicate values. If there are more than 2 columns to check, Please modify as follows

delete from table1
USING table1, table1 as vtable
WHERE (NOT table1.ID=vtable.ID)
AND (table1.field_name=vtable.field_name and table1.field_name1=vtable.field_name1)