var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: age into age band
I have a table of members including date of birth value.
I am not finding any easy way to count the number of members per age band.
0-10, 10-20,20-30 etc.
It seems that the decode function works only for equality tests not for other complex conditions.
Until now, I am using as many count queries as age bands and look whether the date of birth of the member falls between two dates
what i use is
select dob, floor(months_between(sysdate,dob)/120) ag from person;