DELETE FROM 表名 a
WHERE ROWID <> (
SELECT MIN(ROWID)
FROM 表名
WHERE 标识列 = a.标识列
);
转载于:https://my.oschina.net/hengbao666/blog/1574671
DELETE FROM 表名 a
WHERE ROWID <> (
SELECT MIN(ROWID)
FROM 表名
WHERE 标识列 = a.标识列
);
转载于:https://my.oschina.net/hengbao666/blog/1574671