数据库重复数据处理

--Table_Name                表名
--Repetition_Field_Name        重复数据的字段名 
--Retain_Unique_Key         根据哪个字段来保留最后一条数据

--查看重复数据
SELECT * FROM Table_Name WHERE Repetition_Field_Name IN (SELECT Repetition_Field_Name FROM Table_Name GROUP BY Repetition_Field_Name HAVING COUNT(Repetition_Field_Name) > 1) 

--删除全部重复数据
DELETE FROM Table_Name WHERE name in (select name from Table_Name group by name  having count(name) > 1) 

--只保留一条重复数据
DELETE FROM Table_Name 
WHERE 1=1
    AND Repetition_Field_Name IN (SELECT * FROM ( (SELECT Repetition_Field_Name names FROM Table_Name GROUP BY Repetition_Field_Name HAVING COUNT(Repetition_Field_Name)>1) ) a)
    AND Retain_Unique_Key NOT IN (SELECT * FROM ( (SELECT MIN(Retain_Unique_Key) ids FROM Table_Name GROUP BY Repetition_Field_Name HAVING COUNT(Repetition_Field_Name)>1) ) b)

 

如果能达到您的预期结果，请给个赞，后续为大家提供更过的便利，谢谢。。。。。。