Hi Cetin,

you are right.

I have focused to much on the definition of the superfluous records. Your way to define the records to keep is better.

Agnes

>When you have the select, delete is easier.
>
>

Select t1.* From Schnaps t1 ;
>  INNER Join ;
>  (Select Min(iOrder) As iOrder From Schnaps Group By c3) t2 ;
>  ON t1.iOrder == t2.iOrder

>
>

>Delete From Schnaps Where iOrder Not In ;
>   (Select Min(iOrder) As iOrder From Schnaps Group By c3)
>

>
>IMHO message#1416414 is more complex than needed.
>
>Cetin