DENG8623048的博客

MySQL統計，做個筆記 select class班级, sum(case when score>=60 then 1 else 0 end) as 及格人数, sum(case when score<60 then 1 else 0 end) as 不及格人数 from tb1 group by class ---score為分數，class為班級 轉載地址：https://...