Agnes,

Did you checkout this one:

SELECT * ;
	FROM Schnaps ;
	WHERE C3 NOT IN (SELECT C3 FROM (SELECT DISTINCT * FROM Schnaps) X GROUP BY C3 HAVING COUNT(*) > 1) OR ;
				NOT EXISTS(SELECT 1 FROM Schnaps X WHERE c3 = Schnaps.c3 AND iOrder < Schnaps.iOrder)

*Update* Just taking a second look at cetins one... Yeah that seems simpler than the above.



Walter,

>Hi Walter,
>
>thank you.
>
>looks like we all have the focus to much on the positive deletion set. Cetins solution in message#1416554 with the inverted set is much smarter.
>Agnes