1、出生日期来计算年龄：select csrq as csrq ,datediff(year,csrq ,getdate()) as nl from table
2、70年代出生占年龄的百分比：
select rs70*100/zrs as bfb
from (select sum(case when csrq like'1970%'then 1 else 0 end ) as rs70,count(csrq) as zrs from table) a
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024