Re: Compute AVG and excluding 0 values
From: Michael F. Fabacher <senna_at_inetnow.net>
Date: 1996/03/21
Message-ID: <4iptgs$cq8_at_galahad.inetnow.net>#1/1
Date: 1996/03/21
Message-ID: <4iptgs$cq8_at_galahad.inetnow.net>#1/1
In article <4ifqdp$2jn_at_nnrp1.news.primenet.com>,
Stephen McClure <mcclure_at_primenet.com> wrote:
>Is there anyway to exclude rows with 0 values from a "compute avg on"
>statement?
>
A 'more' portable way would to a set operator such as a minus. (minus out the zero columns with a
..
minus
select 0 from dual for example)
Received on Thu Mar 21 1996 - 00:00:00 CET