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