mysql查询学⽣表年龄语句_mysql中⼀张（居民）表按年龄段
查询数据
wxpython在窗口内打开浏览器知识点：
⽤mysql，按年龄段查询⼀张居民的数据(各年龄段居民的个数)
电脑入门学习1.如：查询resident(居民表)，按照各年龄段，统计⼈数
select ageproportion as ‘年龄段‘,count(*) as ‘⼈数‘ from
(
vim编辑器退出保存
SELECT
CASE
when age>0 and age<=10 then ‘0-10岁‘
when age>10 and age<=20 then ‘10-20岁‘
forecast函数用法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.查询结果：
发表评论