query.sql

DELETE FROM
    blah
WHERE
    id NOT IN (
        SELECT
            c.id
        FROM
            blah c
        LEFT JOIN 
            blah d
            ON (
                c.common_field = d.common_field
                AND c.id < d.id
            )
        WHERE
            d.id IS NULL
    )