Re: group by / columns

From: Spencer <spencerp_at_swbell.net>
Date: Sat, 27 Jan 2001 15:28:37 -0600
Message-ID: <74Hc6.23$Pn.5577@nnrp1.sbc.net>

> > Is there any other way I can refer to to expressions in the group by
> clause
>
> Not to my knowledge.
>
> The documentation lists expressions as valid in a GROUP BY but does not
> list positional notation or column aliases. When using an alias Oracle
> will report "ORA_00904: invalid column name" and when using positional
> notation Oracle will report "ORA-00979: not a GROUP BY expression". It
> would appear you are stuck using the actual expression from the select
> statement.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>

yep. matches my experience. in the GROUP BY, you have to use the exact expression that is used in the SELECT list. but it's not so bad... getting an inaccurate result set would be worse... Received on Sat Jan 27 2001 - 15:28:37 CST