删除id重复的数据,留下rowid最小的那条
DELETE from 表 WHERE (id) IN ( SELECT idFROM 表 GROUP BY id HAVING COUNT(id) > 1)
AND ROWID NOT IN (SELECT MIN(ROWID) FROM 表 GROUP BY id HAVING COUNT(*) > 1)
删除id重复的数据,留下rowid最小的那条
DELETE from 表 WHERE (id) IN ( SELECT idFROM 表 GROUP BY id HAVING COUNT(id) > 1)
AND ROWID NOT IN (SELECT MIN(ROWID) FROM 表 GROUP BY id HAVING COUNT(*) > 1)