Why doesn't Oracle SQL allow us to use column aliases in GROUP BY clauses?
Posted
by Mehper C. Palavuzlar
on Stack Overflow
See other posts from Stack Overflow
or by Mehper C. Palavuzlar
Published on 2010-04-21T09:01:15Z
Indexed on
2010/04/21
9:03 UTC
Read the original article
Hit count: 250
This is a situation I'm generally facing while writing SQL queries. I think that writing the whole column (e.g. long case expressions, sum functions with long parameters) instead of aliases in GROUP BY expressions makes the query longer and less readable. Why doesn't Oracle SQL allow us to use the column aliases in GROUP BY clause? There must be an important reason behind it.
© Stack Overflow or respective owner
