Re: stupid sqlplus problem: compute both avg and sum

[Quoted] compute sum of nbr_logins avg of nbr_logins on report

--
[Quoted] Kind Regards,
Frank
<billmil_at_my-deja.com> wrote in message news:8oe1g8$dc6$1_at_nnrp1.deja.com...


> Dan,

>

> Thanks for the suggestion. It makes sense, but unfortunately I haven't


> gotten it or a variant to work.

> >   compute sum nbr_logins on report avg nbr_logins on report

>

> Also, per your comment on the exact syntax, the syntax of COMPUTE, from

> the SQLPlus reference, doesn't mention any "loop"--i.e. the ability to

> specify more function:

>

> COMP[UTE] [function LAB[EL] text ]

>    of {expr|column|alias}

>    on {expr|column|alias|REPORT|ROW}

>

> any other suggestions?

>

> bill milbratz

>

> In article <20000827110635.02963.00000278_at_ng-mg1.aol.com>,

>   danhw_at_aol.com (DanHW) wrote:

> > >How can I compute, using SQLPLUS, both the *sum* and the *average*

 of a


> > >column?


> > >

> > >This seems like pretty basic functionality, but I found:

> > >1) I couldn't get both sums and averages to work on a column

> > >2) the sqlplus manual says "if multiple COMPUTE commands reference

 the


> > >same column in the ON clause, only the last COMPUTE command applies."


> > >

> > >For the record, I tried:

> > >   compute sum label Total of nbr_logins on report

> > >   compute avg label Avg of  nbr_logins avg_min_on_site

> > >total_min_on_site on report

> > >

> > >SQLPLUS would average the "nbr_logins" field, but not summarize it.

> > >

> > >How can I get past this limitation?

> > >

> > >thanks,

> > >

> > >bill milbratz

> > >chicago IL usa

> > >

> >  Only the last STATEMENT is applied, but the stament can have multiple

> > commands. Try

> >

> > compute sum nbr_logins on report avg nbr_logins on report

> >

> > (you will need to look it up for the precise format)

> >

> > HTH

> > Dan Hekimian-Williams

> >

> >

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.