Claudio,

> Lucas, you seem to be deleting every occurrence of a duplicate. Wasn't the
> idea to reduce N occurrences of a value to only one occurrence? I think what
> you need is:

of course you're right.

Yes, this is deleting all duplicates, leaving none.

It's just a matter of how you're reading "deleting all duplicates" - if
it does include the first occurance (and therefore all records) or not.

If leaving the first occurance I'd have done sth. similar, but used the
primary key column instead the rdb$key column since I tend to forget
about this.

Thanks for reminding me about the existence.

Luc.