codice:
DELETE FROM cr_clienti
WHERE cliente_codice IS NULL AND
cliente_piva IN (
 SELECT cliente_piva FROM cr_clienti
 GROUP BY cliente_piva
 HAVING COUNT(cliente_piva) > 1
)