针对学生选课表sc(sno, cno, grade),其中sno为学号,cno为课程号,grade为成绩。以下哪个操作( )统计出每位学生所选课程的最高分和最低分。
选项:
A:select sno,max(grade), min(grade) from sc ;
B:select sno,max(grade), min(grade) from sc order by sno;
C:select sno,max(grade), min(grade) from sc group by sno;
D:select sno,avg(grade), sum(grade) from sc group by sno
发布时间:2024-05-07 19:17:09