select count(kolon1) as kolontopla from table group by kolon1 order by HAVING kolontopla desc