Deleting duplicate rows
DELETE FROM <tablename> a
WHERE rowid > (
SELECT min(rowid)
FROM <tablename> b
WHERE a.keyvalues=b.keyvalues
);
DELETE FROM <tablename> a
WHERE rowid > (
SELECT min(rowid)
FROM <tablename> b
WHERE a.keyvalues=b.keyvalues
);
Comments
Post a Comment