select prin_prec_id from asdk_precase_incident group by prin_prec_id having count(1)>1 select * from ASDK_PRECASE_INCIDENT WHERE PRIN_PREC_ID = (Incidentes encontrados) DELETE FROM ASDK_PRECASE_INCIDENT WHERE PRIN_PREC_ID = (Incidentes encontrados) AND PRIN_INCI_ID = (relaciones encontradas)