参考：不同的策略换除去重复的-记录-在-SQL服务器 [ ^ ]

How can we remove dublicate field form database table even there is no identity column.

Refer: different-strategies-for-removing-duplicate-records-in-sql-server[^]