-
Using aliases with the 'HAVING' clause
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|