DELETE FROM source dup WHERE EXISTS ( SELECT NULL FROM source WHERE dup.field1=source.field1 AND dup.field2=source.field2 AND source.key