表person,字段csrq
查询:0-15岁、16-25岁、26-35岁、36-59岁、60岁以上 人员
select
case when (MONTHS_BETWEEN(SYSDATE, csrq) < 180) then 1
when (MONTHS_BETWEEN(SYSDATE, csrq) < 300) then 2
when (MONTHS_BETWEEN(SYSDATE, csrq) < 420) then 3
when (MONTHS_BETWEEN(SYSDATE, csrq) < 720) then 4
when (MONTHS_BETWEEN(SYSDATE, csrq) >= 720) then 5
else
-1
end
from person
评论