DELETE table
FROM table
LEFT OUTER JOIN (
SELECT MIN( id ) AS id, champ_a_dedoubloner
FROM table
GROUP BY champ_a_dedoubloner
) AS table_1 ON table.id = table_1.id
WHERE table_1.id IS NULL;
DELETE table
FROM table
LEFT OUTER JOIN (
SELECT MIN( id ) AS id, champ_a_dedoubloner
FROM table
GROUP BY champ_a_dedoubloner
) AS table_1 ON table.id = table_1.id
WHERE table_1.id IS NULL;
Leave feedback about this