关于：分组计数の话题！

两种方法实现mysql分组计数，范围汇总

• 时光、生本性 发布于 2020-07-06 10:37
• 收藏 MySQL 分组计数 MySQL 范围汇总

第一种:常规操作SELECTSUM(ddd) AS count_days,CASEWHEN aa.days >= 1AND aa.days < 3 THEN'1-3'WHEN aa.days >= 3AND aa.days < 5 THEN'5-3'ELSE'5+'END AS groupby_daysFROM(SELECTSUM(1) AS ddd,daysFROMtour_groupGROUP BYdays) AS aaGROUP BYg..