sql语句删除一张表中重复数据

来自 王涛 同志的指导

DELETE FROM product WHERE searchdate IN (SELECT sd FROM (SELECT a.searchdate sd FROM product a GROUP BY a.searchdate HAVING count(a.searchdate) > 1 ) t)AND iid NOT IN (SELECT mid FROM(SELECT min(b.iid) mid FROM product b GROUP BY b.searchdate HAVING count(b.searchdate) > 1) st
);