Re: Compute AVG and excluding 0 values
Date: 1996/03/21
Message-ID: <NEWTNews.827478267.2201.elric_dm_at_dialup.netvision.net.il>#1/1
Looks like you should have used NULL instaed of 0. think about it ...
In Article<4ifqdp$2jn_at_nnrp1.news.primenet.com>, <mcclure_at_primenet.com> write:
> Path:
news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.i
nternetmci.com!in2.uu.net!nntp.news.primenet.com!news.primenet.com!mcclure
> From: Stephen McClure <mcclure_at_primenet.com>
> Newsgroups: comp.databases.oracle
> Subject: Compute AVG and excluding 0 values
> Date: 16 Mar 1996 18:38:01 -0700
> Organization: Primenet (602)395-1010
> Lines: 6
> Sender: root_at_primenet.com
> Message-ID: <4ifqdp$2jn_at_nnrp1.news.primenet.com>
> X-Posted-By: mcclure_at_usr2.primenet.com
>
> Is there anyway to exclude rows with 0 values from a "compute avg on"
> statement?
>
> --
> RESPECT - "Treat the earth well ... It was not given to us by our
> parents... It was lent to us by our children."
Received on Thu Mar 21 1996 - 00:00:00 CET