Is it possible to use aliases as part of a 'HAVING' clause following a 'GROUP BY' statement in Oracle8i? I've tried using a column alias created in the 'SELECT' statement like this, but get the error "ORA-00904: invalid column name," even though the name was clearly declared earlier. Can this be done, or am I mistaken?
