如何在MySQL中随意装箱? [英] How to bin arbitrarily in MySQL?

问题描述

我有一个表，其中的一列列出了用户的年龄.我想将年龄分组到任意分组中(13-17、18-25等)，然后能够按这些分组进行分组并统计每个组中的用户.如何在查询中完成此操作?

I have a table with a column that lists ages of users. I want to bin ages in arbitrary groupings (13-17,18-25, etc) and then be able to group by those bins and count users in each group. How can I accomplish this in a query?

推荐答案

SELECT CASE WHEN age BETWEEN 13 AND 17 THEN '13-17' 
            WHEN age BETWEEN 18 AND 25 THEN '18-25' 
            ELSE '26+' END AS AgeGroup,
    COUNT(*) AS total
FROM MyTable
GROUP BY AgeGroup

这篇关于如何在MySQL中随意装箱?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！