Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with aggregate query

Re: Help with aggregate query

From: Randy Harris <notvalid_at_no.spam>
Date: Wed, 13 Apr 2005 19:27:23 GMT
Message-ID: <voe7e.1961$716.251@newssvr19.news.prodigy.com>


"Kevin Crosbie" <caoimhinocrosbai_at_yahoo.com> wrote in message news:1113389220.0b2574c0299a35fed06aa75ccb45c754_at_teranews...
> You could try something like:
> SUM(case when e.xstatus IN ('A','P','X') then 1 else 0 end) as regist
> instead of COUNT(e.xlocator)
>
> and then remove the OR e.xstatus IN ('A','P','X') from the where clause.

This sure seems like exactly what I need. In my original post, however, I failed to mention that I am still using dinosaur version. I can't find CASE in the 8i docs and am guessing that it was added afterward. Is there another way that I can accomplish the same thing with 8i? Received on Wed Apr 13 2005 - 14:27:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US