| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: select a/avg(b) .... ?
Thank you, helps a lot....
James Lorenzen wrote:
>
> Sorry, the brain was not fully engaged in my previous post. This query will
> work.
>
> select c1.a, c1.a/c2.avg_b from c c1, (select avg(b) avg_b from c) c2 ;
>
> NOTE: It uses an inline view to get the average.
>
> James
>
> In article <7gup34$53i$1_at_nnrp1.deja.com>,
> James Lorenzen <james_lorenzen_at_allianzlife.com> wrote:
> > 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
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
--
Karl Liebknecht Straße 25; 14476 Golm; Tel: (+49 030) 84131542 * NEW MAIL ADDRESS * mailto:kloska_at_mpimp-golm.mpg.deReceived on Fri May 07 1999 - 09:07:09 CDT
 |
 |