MySQL Group By和按照年龄划分包围 [英] MySQL Group By and bracketing according to age

问题描述

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屋！