> 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
