查询选修了a001号课程的学生的最高成绩()
查询选修了a001号课程的学生的最高成绩()
A.select cid,max(grade) from student where cid=’a001’ group by cid
B.select cid, max(grade) from student group by cid having cid=’a001’
C.select cid, max(grade) from sc where cid=’a001’ group by cid
D.select cid, max(grade) from course where cid=’a001’ group by cid
正确答案:select cid, max(grade) from sc where cid=’a001’ group by cid
Tag:SqlServer数据库原理与应用 成绩 课程
时间:2023-12-26 10:57:50
- 上一篇:用于统计最高值的聚合函数是()
- 下一篇:用于统计最低值的聚合函数是()