MySQL Group By和按照年龄划分包围 [英] MySQL Group By and bracketing according to age
本文介绍了MySQL Group By和按照年龄划分包围的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
MySQL可以根据年龄段处理数据分组吗?
在我的用户表中,年龄值是他们的实际年龄。我想根据年龄段进行分组。例如:
年龄在1岁以下的为1岁,1-4岁为2岁5-9岁。如同age3等等。
解决方案
是的。您可以在 CASE
类别中进行分区。
SELECT
COUNT(*),
CASE
当年龄< 1然后'age1'
当年龄在1和4之间时'age2'
当年龄在4和9之间时'age3'
ELSE'age4'
END作为年龄段
FROM children
GROUP BY ageband;
Is that possible that MySQL can handle grouping of data according to age bracket?
In my users table, age value is their actual age. I want to group them according to age bracket. For example:
ages below 1 year old as age1, 1-4 yrs as age2, 5-9 yrs. old as age3 and so on.
解决方案
Yes. You do the partitioning in a CASE
clase.
SELECT
COUNT(*),
CASE
WHEN age < 1 THEN 'age1'
WHEN age BETWEEN 1 AND 4 THEN 'age2'
WHEN age BETWEEN 4 AND 9 THEN 'age3'
ELSE 'age4'
END AS ageband
FROM children
GROUP BY ageband;
这篇关于MySQL Group By和按照年龄划分包围的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文