Arno Brinkman wrote:

>
> I thought it was the intention to leave only 1 record from all the duplicates, but i could
> misunderstood the question.
>

No, you're correct about the intention, and I'd missed the fact that
yours is a correlated subquery so should (one hopes) be executed once
for each record considered for deletion... I think..

Regards,


Ann