select *,count(campo) from tabella group by campo