Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Decode and ranges?
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 22Received on Sun Feb 28 1999 - 14:39:36 CST
![]() |
![]() |