The column MYCNT does not exist, it's created by aggregate function. As such it should be checked in HAVING clause.

...
HAVING MYCNT > 1
...

>Can someone please explain why the following sql select gives error "column MYCNT not found"?
>
>

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

>
>Thank you.