-- 查找重复条目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表如下:
则查找重复条目的搜索结果应为:
删除重复条目后的结果为: