我见过一对夫妇为这个解决方案，但我想知道最好的和最有效的方法是什么，重复数据删除的表。你可以用code（SQL等）来说明你的观点，但我只是在寻找基本算法。我以为会有已经是这个SO上的问题，但我没能找到一个，所以如果它已经存在，只是给我一个头了。

I've seen a couple of solutions for this, but I'm wondering what the best and most efficient way is to de-dupe a table. You can use code (SQL, etc.) to illustrate your point, but I'm just looking for basic algorithms. I assumed there would already be a question about this on SO, but I wasn't able to find one, so if it already exists just give me a heads up.

（只是为了澄清 - 我指的是摆脱在具有增量自动PK和一台重复的有一个是一切，但在PK场重复某些行）

(Just to clarify - I'm referring to getting rid of duplicates in a table that has an incremental automatic PK and has some rows that are duplicates in everything but the PK field.)

推荐答案

删除重复记录：

http://www.databasejournal.com/features/mssql/article.php/1438651/Removing-Duplicate-Records.htm

如何从一个表中的SQL Server删除重复的行：

http://support.microsoft.com/kb/139444

删除重复的条目/行的MySQL数据库表：

http://www.justin-cook.com/wp/2006/12/12/remove-duplicate-entries-rows-a-mysql-database-table/

从表在SQL Server中删除重复：

http://www.simple-talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/

这应该让你去，如果你需要更多的例子，请让我知道。

That should get you going, if you need more examples please let me know.