2024-09-03 厉飞雨 阅读(55) 评论(0) 赞(4)

mysql 数据库case判断语句 case when 条件 then 结果 end mysql> select teacher.tname,course.cname,concat(floor(count(case when sc.score>=60 then 1 end)/count(*)*100),"%") from t...