>you can change >COUNT(c1 + c2 ) > >into > >count(*) && just counting the number of records anyway > >>
>>DELETE FROM Schnaps; >> WHERE i1 IN ; >> (; >> SELECT S.i1 ; >> FROM Schnaps AS S; >> INNER JOIN; >> ( ; >> SELECT c3, MIN(i1) AS i1; >> FROM Schnaps ; >> GROUP BY 1 ; >> HAVING ( COUNT(c1 + c2 ) > 1) ; >> ) AS AA ; >> ON S.c3 == AA.c3; >> AND S.i1>AA.i1; >> ) >>>>