2020-12-05

使用sql查询男女人数和百分比

select nvl(count(1),0) as num,
	   trim(b.sex) as sex,
	   nvl(concat(round(ratio_to_report(count(b.sex)) over(),2)*100,'%'),0) as bfb
from info_base b
where 1=1
group by trim(b.sex)

使用sql根据身份证算出年龄

select (to_number(to_char(sysdate,'yyyy')) - to_number(substr(t.certificate_no),7,4) age
from info_base t