DELETE FROM tabla WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM tabla GROUP BY columna1, columna2, columna3...);