查询重复字段:
SELECT 字段,COUNT(*) FROM 表名 GROUP BY 字段 HAVING COUNT(*) > 1;
删除重复字段:
DELETE FROM 表名 WHERE rowid NOT in (SELECT MIN(ROWID) FROM 表名GROUP BY 字段);
COMMIT;
查询重复字段:
SELECT 字段,COUNT(*) FROM 表名 GROUP BY 字段 HAVING COUNT(*) > 1;
删除重复字段:
DELETE FROM 表名 WHERE rowid NOT in (SELECT MIN(ROWID) FROM 表名GROUP BY 字段);
COMMIT;