sql根据出生日期按年龄段统计用户

select nnd as age ,count(*) as num from
(
 select 
 case 
  when to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy') >= '0' and to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy') <= '10' then '10岁以下'
  when to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy') >= '11' and to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy')<='20' then '11-20'
  when to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy') >= '21' and to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy')<='30' then '21-30'
  when to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy') >= '31' and to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy')<='40' then '31-40' 
  when to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy') >= '41' and to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy')<='50' then '41-50' 
  when to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy') >= '51' and to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy')<='60' then '51-60' 
  when to_char(sysdate,'yyyy')-to_char(BIRTHDAY,'yyyy') >'60'  then '60以上' 
 end 
 as nnd,fname from pcm_friends
)
a 
group by nnd

转载请注明：天狐博客 » sql根据出生日期按年龄段统计用户