case when语法 case when 判断条件1 then 结果1 when 判断条件2 then 结果2 ... else 结果3 end 题目: 使用case when解决: select (case when age>=25 then "25岁及以上" else "25岁以下" end) as age_cut,count(id) from user_profile group by age_cut