DELETE
FROM
people
WHERE
peopleId IN (SELECT peopleId FROM people GROUP BY peopleId HAVING count(peopleId) > 1)
AND rowid NOT IN (SELECT min(rowid) FROM people GROUP BY peopleId HAVING count(peopleId) > 1)
转载于:https://www.cnblogs.com/wulm/p/8529738.html