成绩表
userid 学生姓名,kechengid课程,category1id班级,semesterid学期
学生表
求某一学期,某个班的成绩排名
select nickname,sum(score) from student left join achievement
on achievement.userid=student.id group by achievement.userid
where student.category1id=13 and semesterid=4;
成绩表
userid 学生姓名,kechengid课程,category1id班级,semesterid学期
学生表
求某一学期,某个班的成绩排名
select nickname,sum(score) from student left join achievement
on achievement.userid=student.id group by achievement.userid
where student.category1id=13 and semesterid=4;