--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)
如果能达到您的预期结果,请给个赞,后续为大家提供更过的便利,谢谢。。。。。。