SELECT count(1) as counts,
ELT(INTERVAL(score, 0, 20, 40, 60, 80, 100), '0-20', '20-40', '40-60', '60-80', '80-100') as score_level
FROM bde_student_score
GROUP BY score_level
mysql分区间统计
最新推荐文章于 2024-07-23 13:22:23 发布
SELECT count(1) as counts,
ELT(INTERVAL(score, 0, 20, 40, 60, 80, 100), '0-20', '20-40', '40-60', '60-80', '80-100') as score_level
FROM bde_student_score
GROUP BY score_level