DELETE FROM t_application WHERE id NOT IN (SELECT minid FROM (SELECT MIN(t.id) AS minid FROM t_application t GROUP BY t.name) b);