In the target make the column as the key column and run the job.

delete table tablename where rowid not in Select * from tablename group by column name