Using aliases with the 'HAVING' clause
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Using aliases with the 'HAVING' clause

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Question 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?

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

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

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width