Re: SQL-statement

On 2005-04-20, Ken Denny <ken_at_kendenny.com> wrote:
> I would do one thing differently than Rene. I would calculate the
> non-active a bit differently. I would use this to calculate non-active:
>
> sum(decode(nvl(e.active,0),0,1,0))

yes, that seems reasonable. Thanks
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/