从表中删除重复记录 [英] Deleting duplicate records from table

问题描述

rowid如何从表中删除重复记录。

解决方案

 DELETE 
来自MyTable 
 WHERE ID NOT IN 
（
 SELECT MAX（ID）
来自MyTable 
 GROUP BY DuplicateColumn1，DuplicateColumn2，DuplicateColumn3）

< br $> b $ b

http://blog.sqlauthority.com/2007/03/01/sql-server-delete-duplicate-records-rows/



http://www.orafaq.com/faq/how_does_one_eliminate_duplicates_rows_from_a_table

How the rowid works in deleting duplicate records from table.

解决方案

DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1, DuplicateColumn2, DuplicateColumn3)

http://blog.sqlauthority.com/2007/03/01/sql-server-delete-duplicate-records-rows/

http://www.orafaq.com/faq/how_does_one_eliminate_duplicates_rows_from_a_table

这篇关于从表中删除重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！