... HAVING MYCNT > 1 ...
>select MYFLD, COUNT(*) as MYCNT from MYTABLE where MYCNT > 1 group by MYFLD >