DELETE FROM tableName WHERE id IN (SELECT bid FROM (SELECT max(id) as bid FROM tableName GROUP BY (cid) HAVING COUNT(cid)>1) as b);