DELETE FROM wbxx
WHERE id not in
(
SELECT id FROM (
SELECT id FROM wbxx GROUP BY namex HAVING count(id) = 1
UNION
SELECT min(id) FROM wbxx GROUP BY namex HAVING count(id) > 1
) AS temptable1
)
MySQL试去重语句测试having使用学习不好意思,将count(*)换为count(id),使用不能偷懒DELETE FROM wbxx WHERE id not in( SELECT id FROM ( SELECT id FROM wbxx GROUP BY namex HAVING count(id) = 1 UNION SELECT min(id)...