Código:
DELETE from SRRUTA2 t1 left join (
select CR2, CR3, CR4, CR5, CR6, CR7
from SRRUTA2
group by CR2, CR3, CR4, CR5, CR6, CR7
having count(1)>1
) t2 on t1.CR2=t2.CR2 and t1.CR3=t2.CR3
where t2.CR2 is null
Mens. 102, Nivel 15, Estado 1, Línea 1
Sintaxis incorrecta cerca de 't1'.
Mens. 102, Nivel 15, Estado 1, Línea 6
Sintaxis incorrecta cerca de 't2'.
:p