Select count(codice) as totCodici from tua_tabella