SQL 分组客户按年龄给定的出生日期

最好的方法可能是用您的年龄类别制作一张表格并进行连接

SELECT *
FROM Personal_details p
INNER JOIN age_categories ac 
    ON TIMESTAMPDIFF(YEAR, p.birthday, CURDATE()) 
        BETWEEN ac.age_min AND ac.age_max

另一种方法是使用CASE但不像真实表格那样清晰，您可以更新以创建新的年龄类别...( 0-18; 18-30; ...)

对于 CASE 版本：

SELECT *,
    CASE 
        WHEN TIMESTAMPDIFF(YEAR, p.birthday, CURDATE())
            BETWEEN 0 AND 10 THEN '0-10'
        WHEN TIMESTAMPDIFF(YEAR, p.birthday, CURDATE())
            BETWEEN 11 AND 20 THEN '11-20'
        -- ...
    END AS age_categorie

FROM Personal_details p