remove duplicates

DELETE   FROM sametarget
WHERE    id NOT IN
         (
         SELECT  MIN(id)
         FROM    sametarget
         GROUP BY
                 cmp1
         ,       cmp2
         ,       ki1
         ,       ki2
         );