select campo,count(campo) as quanti from tabella group by campo;