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