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

Sebastian; The AVG function is a group funtion and the "a" is not a group function. If you need to retrieve a list of all rows with "a/avg(b)"; then this will work:

select c1.a/avg(c2.b) from c c1, c c2 ;

HTH
    James

In article <3732ACEC.F3A7560D_at_mpimp-golm.mpg.de>,   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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 08:16:23 CDT