#就是两个条件,一是找到要删的,而是找到哪些需要留下来 ps.mysql这样写可能有些问题,需要在删除的时候,把id用select再包一层,否则会报错
delete
FROM
table_demo
WHERE
NAME IN (
SELECT
NAME
FROM
table_demo
GROUP BY
NAME
having
count(1) > 1
)
AND id NOT IN (
SELECT
min(id)
FROM
table_demo
GROUP BY
NAME
having count(1) >1
)