Re: Decode and Ranges?

Hi,

This should look like
select gender_cd,

       , sum(decode(round(months_between(birth_dt,sysdate)/12) between 6 and 10,1,0)

       , sum(decode(round(months_between(birth_dt,sysdate)/12) between 11 and 15, 1, 0)
from members
where ...
group by gender_cd

Hth,

Sybrand Bakker, Oracle DBA

JCEdleman wrote:

> Hi,
>
> Here is what I am trying to do:
>
> In one SQL statement using Decode ( or another function you might suggest),
> validate a numeric range so . . .
>
> If the row value is between 6 and 10 display a count of records.
>
> Psydo -code:
> Select gender_cd,
> count(decode(round(months_between(birth_dt,sysdate)/12),between 6 and 10, total
> count))) "Age 6-10"
> from members
> where . . . . .
>
> Result would look like this:
>
> Age 6-10 Age 11-15
> Males 5 10
> Females 6 22

Received on Sun Feb 28 1999 - 23:49:32 CST