``` DELETE FROM project_typeself_del WHERE typename IN(SELECT typename FROM (SELECT typename FROM project_typeself_del GROUP BY typename HAVING COUNT(typename) > 1) a) AND id NOT IN(SELECT * FROM (SELECT MIN(id) FROM project_typeself_del GROUP BY typename HAVING COUNT(typename) > 1) b) ```