SELECT COUNT(*) AS C, CODICE FROM TABELLA GROUP BY CODICE ORDER BY C DESC