select studentId,count(score)'考试科目数量',
sum(score)'学生平时总成绩',
avg(score)'学生平均成绩'
from result INNER JOIN student
GROUP BY studentId;
select studentId,id,userName,testName,score,introduce
from result right join student on result.studentId=student.id;
select * from result INNER JOIN student on result.studentId=student.id;
select * from result left JOIN student on result.studentId=student.id;
select * from result right JOIN student on result.studentId=student.id;
MySQL分组查询实例
最新推荐文章于 2024-07-14 19:46:27 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)