DELETE FROM table_name
WHERE "id" NOT IN
(SELECT MAX("dt"."id")
FROM table_name As dt
GROUP BY "dt"."field_that_records_have_duplicate_info_in", "dt"."another_field_that_records_have_duplicate_info_in");
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment