Using aliases with the 'HAVING' clause

[Xan]

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?

[hrishy]

Hi

This is a restriction on the group by and having clauses , they cannot use aliased columns.

regards
Hrishy