#MySQL#查找表中重复条目 删除重复条目

-- 查找重复条目SELECT ID,COUNT(ID)FROM IDrecordGROUP BY IDHAVING COUNT(ID) > 1-- 删除重复条目DELETE FROM IDrecord WHERE SerialNo NOT IN (SELECT t.max_id from (SELECT MAX(SerialNo) as max_id from IDrecord GROUP BY ID) as t)

假设IDrecord表如下：

则查找重复条目的搜索结果应为：

删除重复条目后的结果为：