2,723
社区成员
发帖
与我相关
我的任务
分享
Select 毕业学校,Count(*) As 总人数,Sum(Iif(名次<=100,1,0)) As 前100名,;
Sum(Iif(Between(名次,101,200),1,0)) As 前200名,Sum(Iif(Between(名次,201,300),1,0)) As 前300名,;
Sum(Iif(Between(名次,301,400),1,0)) As 前400名 From 学生成绩表 Group By 毕业学校 Order By 毕业学校