Re: select a/avg(b) .... ?

Hi, Sebastian.

        Try something like this...

select a/b_avg from c, (select avg(b) b_avg from c);

Hth,
-Jeff Guttadauro

On Fri, 07 May 1999 11:05:49 +0200, Sebastian Kloska <kloska_at_mpimp-golm.mpg.de> wrote:

> Hi
>
> I'm currently trying to solve a rather simple problem in Oracle8 end
>got
> stucked.
>
> What I have in mind is a query which would look like
>
> select a/avg(b) from c;
>
> Quite simple and I thing not so uncommon, but oracle complains about
> the avg statement. In various SQL-handbooks they write that this is
> not allowed because avg is an aggregate function with only one result
> per select statment (or more if you add a group by).
>
> Nice explanation for theoretical database design, but how do I get
> my results ?
>
> thank you
>
> Sebastian
>
>--
>======================================================================
>Dr. Sebastian Kloska; Max-Planck Institut für Mol. Pflanzenphysiologie
>Karl Liebknecht Straße 25; 14476 Golm; Tel: (+49 030) 84131542
>* NEW MAIL ADDRESS * mailto:kloska_at_mpimp-golm.mpg.de
Received on Fri May 07 1999 - 09:30:14 CDT