How to delete Multiple records having same value, Using SQL

DELETE
FROM cb_entity_samples A
WHERE ROWID >
  (SELECT MIN(rowid)
  FROM cb_entity_samples B
  WHERE A.fk_specimen = B.fk_specimen
  )