mysql查询学生表年龄语句_mysql中一张（居民）表按年龄段查询数据

知识点：

用mysql,按年龄段查询一张居民的数据(各年龄段居民的个数)

1.如：查询resident(居民表)，按照各年龄段，统计人数

2.mysql语句如下：

select ageproportion as ‘年龄段‘,count(*) as ‘人数‘ from

(

SELECT

CASE

when age>0 and age<=10 then ‘0-10岁‘

when age>10 and age<=20 then ‘10-20岁‘

when age>20 and age<=30 then ‘20-30岁‘

when age>30 and age<=40 then ‘30-40岁‘

when age>40 and age<=50 then ‘40-50岁‘

when age>50 and age<=60 then ‘50-60岁‘

else ‘60岁以上‘

END

as ageproportion from resident

)a GROUP BY ageproportion

3.查询结果：