Code Snippet

Just another Code Snippet site

[SQL] Delete duplicates

DELETE FROM table
LEFT OUTER JOIN (
        SELECT MIN(id_field) as id, field1, field2
        FROM table
        GROUP BY field1, field2
    ) AS table_1
    ON table.id = table_1.id
WHERE table_1.id IS NULL


Comments are currently closed.