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


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

Original text of this message