DELETE FROM tableName WHERE id IN (SELECT id FROM (SELECT id ,count(*) AS count FROM tabelName WHERE HAVING count>1) AS a)