delete duplicate records in two tables ?

Question

delete duplicate records in two tables ? how many ways to delete duplicate records ? examples

Bharathi Raja · Answer

DELETE dupes FROM MyTable dupes MyTable fullTable WHERE dupes.dupField = fullTable.dupField AND dupes.secondDupField = fullTable.secondDupField AND dupes.uniqueField > fullTable.uniqueField DELETE FROM MyTable LEFT OUTER JOIN ( SELECT MIN (RowId) as RowId Col1 Col2 Col3 FROM MyTable GROUP BY Col1 Col2 Col3 ) as KeepRows ON MyTable.RowId = KeepRows.RowId WHERE KeepRows.RowId IS NULL

Rajkiran Swain · Answer

DELETE a FROM a -- first table INNER JOIN b -- second table ON b.ID = a.ID AND b.Name = a.Name AND b.Foo = a.Foo delete * from table 1 intersect select * from table 2

Ramesh Palanivel · Answer

You can compare both tables and you can delete