删除表中的重复行 [英] Deleting duplicate rows in a table

问题描述

朋友们，

请告诉我如何删除表中的重复行吗?

Hi friends,

Please tell me how to delete a duplicate row in a table?

推荐答案

检查一下:

sql-server-2005-2008-delete-duplicate-rows [ ^ ]

How_to_Delete_Duplicate_Records_from_an_SQL_Server_Table.html [

check this out:

sql-server-2005-2008-delete-duplicate-rows[^]

How_to_Delete_Duplicate_Records_from_an_SQL_Server_Table.html[^]

hope it helps :)

DELETE FROM Table1 WHERE Col1 NOT IN (SELECT MIN(Col1) FROM Table1 GROUP BY DupCol1, DupCol2, DupCol3)

我现在在手机上可以了"不能提供适当的帮助，但请访问sqlservercentral.com.我记得有人在那儿问过这个问题，= D

I''m on my phone now so can''t help properly, but check out sqlservercentral.com. I remember someone asking that question there and it was resolved =D

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