Sentencia para borrar filas

[GeriReshef]

Intentaria asi:

Código SQL:

WITH T AS
(SELECT *,
    COUNT(CASE WHEN Producto IN ('A','B') THEN 1 END) OVER(Partition BY Cliente) N
FROM    MiTabla)
DELETE
FROM    T
WHERE   N=2
    AND Producto='B';