MYSOL分组查询

最新推荐文章于 2024-05-30 14:59:09 发布

2401_83905280

最新推荐文章于 2024-05-30 14:59:09 发布

阅读量271

点赞数 5

文章标签：数据库前端 javascript

本文链接：https://blog.csdn.net/2401_83905280/article/details/137270922

版权

#分组的时候仅显示我们分组的列信息，其他用于计算
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;