
> So, according to Oracle's view of the world, HAVING is orrect 
> because it
> rejects aliases, but GROUP BY is broken because it accepts them.

Just because it is more powerful than the standard does not mean it is
broken.
The only thing, that is broken is that the alias is taken before the
colname,
and thus results in wrong output for a standard conformant query.

Andreas

Thu, 16 Dec 1999 17:22:54 +0100
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVING