Can use use computed fields on the "having" part of select?I have tried:select a,b, count(*) as dups_count from some_table having dups_count > 1;
and it gives me the error "Attribute 'dups_count' not found"