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)If the first
DELETE FROM Schnaps WHERE iOrder NOT IN (; SELECT iOrder ; 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))
> create cursor Schnaps ; > ( c1 c(1), ; > c2 c(1),; > c3 c(1),; > iOrder I ; > ) > > insert into Schnaps values ('A', 'a', '1',1) > insert into Schnaps values ('A', 'b', '2',2) > insert into Schnaps values ('A', 'b', '3',3) > insert into Schnaps values ('A', 'b', '3',4) > insert into Schnaps values ('B', 'c', '4',5) > insert into Schnaps values ('B', 'd', '4',6) >>
>('A', 'a', '1',1) >('A', 'b', '2',2) >('A', 'b', '3',3) >('B', 'c', '4',5) >>