今天面试遇到个题按10分每组分组查出学生表中每组学生大于15人的人数select count(name), floor(score / 10) f from student group by f having count(name) > 15;因为直接用score/10的话会带精度,只能用函数;ceil()向上取整,floor()向下取整,round()四舍五入
今天面试遇到个题按10分每组分组查出学生表中每组学生大于15人的人数select count(name), floor(score / 10) f from student group by f having count(name) > 15;因为直接用score/10的话会带精度,只能用函数;ceil()向上取整,floor()向下取整,round()四舍五入