delete duplicates in column1 and column2

**JohansonevR** · Jan 9, 2011 03:57

hi,
this is what the table looks like table Product
I need to delete the duplicate in 'Power Supply' and 'Motherboards' fields
I've tryed

Code:

Delete from Product where `Power Supply`=`Motherboards`

but it is not working .
Any idea how to delete them ?

**r937** · Jan 9, 2011 04:54

delete both duplicates, or only one of them?

**JohansonevR** · Jan 9, 2011 05:43

the 1 located in the `Motherboards` column based on the result from `Power Supplies` column.

**r937** · Jan 9, 2011 07:28

Code:

DELETE t2 
  FROM Product AS t1 
INNER 
  JOIN Product AS t2 
    ON t2.Motherboards = t1.`Power Supply`

as always, back up your data before running any SQL that you got off teh interwebs

**JohansonevR** · Jan 9, 2011 08:13

Tnx for your answer.
I've inserting the values without the duplicates.

User Tag List