DELETE FROM spider_927
WHERE 1=1
AND title in (SELECT * FROM ( (SELECT title titles FROM spider_927 GROUP BY title HAVING COUNT(title)>1) ) a)
AND id not in (SELECT * FROM ( (SELECT MIN(id) ids FROM spider_927 GROUP BY title HAVING COUNT(title)>1) ) b)
原文：https://www.cnblogs.com/xiujin/p/11515744.html