select a.orgcode,
a.orgname,
a.nd,
a.yd,
sum(case when substr(to_char(sysdate,‘yyyymmdd’),1,4)-substr(to_char(a.csrq08,‘yyyymmdd’),1,4)<=29 then 1 else 0 end ) as aaa,–‘29岁以下’
sum(case when substr(to_char(sysdate,‘yyyymmdd’),1,4)-substr(to_char(a.csrq08,‘yyyymmdd’),1,4)>=30 and substr(to_char(sysdate,‘yyyymmdd’),1,4)-substr(to_char(a.csrq08,‘yyyymmdd’),1,4)<=39 then 1 else 0 end ) as bbb,–‘30-39岁’
sum(case when substr(to_char(sysdate,‘yyyymmdd’),1,4)-substr(to_char(a.csrq08,‘yyyymmdd’),1,4)>=40 and substr(to_char(sysdate,‘yyyymmdd’),1,4)-substr(to_char(a.csrq08,‘yyyymmdd’),1,4)<=49 then 1 else 0 end ) as ccc,–‘40-49岁’
sum(case when substr(to_char(sysdate,‘yyyymmdd’),1,4)-substr(to_char(a.csrq08,‘yyyymmdd’),1,4)>=50 and substr(to_char(sysdate,‘yyyymmdd’),1,4)-substr(to_char(a.csrq08,‘yyyymmdd’),1,4)<=54 then 1 else 0 end ) as ddd,–‘50-54岁’
sum(case when substr(to_char(sysdate,‘yyyymmdd’),
急急急!!!SQL 年龄段查询 语句更换
最新推荐文章于 2023-09-20 10:02:57 发布