如何重新保存重复行，只保留表中的一条记录？ [英] how to reomove duplicate rows keeping only one record in the table?

问题描述

我有一个表，其中一些行是重复的（不是所有行）一次，两次或三次，所以如何删除重复多于表中的行...请为此提供一个解决方案..

I have one table in that some rows are duplicated(not all rows) one,two or three times so how to remove the rows that repeated more than ones in the table..please give one solution for this..

推荐答案

有很多方法：

There are many ways:

WITH tblTemp as
(
SELECT ROW_NUMBER() Over(PARTITION BY Col1,Col2 ORDER BY Col1)
   As RowNumber,* FROM [table_name]
)
DELETE FROM tblTemp where RowNumber >1

或点击链接删除重复的行 [ ^ ]

这篇关于如何重新保存重复行，只保留表中的一条记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！