【文件属性】:
文件名称:分组查询—HAVING-SqlServer教材,基础学习(基础篇)
文件大小:4.56MB
文件格式:PPT
更新时间:2021-04-25 22:08:51
SqlServer
分组查询—HAVING
SELECT StudentID AS 学员编号,CourseID AS 内部测试, AVG(Score) AS 内部测试平均成绩
FROM Score
GROUP BY StudentID,CourseID
HAVING COUNT(Score)>1