一、删除重复数据(重复导入了数据)(联合主键):
delete from 表名
WHERE (字段名1 || 字段名2) IN
(SELECT 字段名1 || 字段名2
FROM 表名
GROUP BY 字段名1, 字段名2
HAVING COUNT(*) > 1)
AND ROWID IN (SELECT MIN(ROWID)
FROM 表名
GROUP BY 字段名1, 字段名2
HAVING COUNT(*) > 1);
注:1、字段名1与字段名2相当于组合主键
2、此处主要运用数据库默认rowid(每天记录的物理地址,递增且唯一),来区分重复数据
delete from 表名
WHERE (字段名1 || 字段名2) IN
(SELECT 字段名1 || 字段名2
FROM 表名
GROUP BY 字段名1, 字段名2
HAVING COUNT(*) > 1)
AND ROWID IN (SELECT MIN(ROWID)
FROM 表名
GROUP BY 字段名1, 字段名2
HAVING COUNT(*) > 1);
注:1、字段名1与字段名2相当于组合主键
2、此处主要运用数据库默认rowid(每天记录的物理地址,递增且唯一),来区分重复数据