Well, this is a fine statement to delete duplicates in a table :

DELETE FROM
   table1 A
WHERE
  A.rowid >
   ANY (
     SELECT
        B.rowid
     FROM
        table1 B
     WHERE
        A.ID = B.ID and
        any additional condition
        )
   and other conditions on A;