How to use having on un-aggregate field in MySQL?

Question

select xx as fieldA from ... group by xxx having fieldA is not null

I found that having has no effect

Answer 1

May be :

 select xx as fieldA from ... where fieldA is not null group by xxx having 

help you