文件名称:分组查询—HAVING-SqlServer教材,基础学习(基础篇)
文件大小:4.56MB
文件格式:PPT
更新时间:2024-05-15 15:55:31
SqlServer
分组查询—HAVING SELECT StudentID AS 学员编号,CourseID AS 内部测试, AVG(Score) AS 内部测试平均成绩 FROM Score GROUP BY StudentID,CourseID HAVING COUNT(Score)>1
文件名称:分组查询—HAVING-SqlServer教材,基础学习(基础篇)
文件大小:4.56MB
文件格式:PPT
更新时间:2024-05-15 15:55:31
SqlServer
分组查询—HAVING SELECT StudentID AS 学员编号,CourseID AS 内部测试, AVG(Score) AS 内部测试平均成绩 FROM Score GROUP BY StudentID,CourseID HAVING COUNT(Score)>1