根据日期计算年龄并分组显示 select extract(year from age(now() , 表.出生日期)) AS age, count(0) As ageNum from 表 group by age;