Bail out data duplicates with SQL

A good relational database model should avoid data duplicates. But sometimes you get working on a migration project. Maybe a project with a bad data basis. The migration process seems to work, it looks good. Then it happens: the migration script abor...