In data migration, there is often a need to delete duplicate rows as part of data cleanup. Which statement works best?
DELETE WITH
DELETE JOIN
DELETE DISTINCT
DELETE DUPS