Zduplikowanie wartosći w bazie/tabeli

SELECT code, COUNT(*) c FROM `pos` GROUP BY code HAVING c > 1;