针对学生选课表sc(sno, cno, grade),其中sno为学号,cno为课程号,grade为成绩。以下( )语句可查询选修了两门以上成绩在90分以上课程的学生学号。
A、selectsno from sc wheregrade>90 group by sno having count(distinct sno)>2;
B、selectsno from sc wheregrade>90 group by sno having count(cno)>2;
C、selectsno from sc wheregrade>90andcount(*)>2 group by sno;
D、selectsno from sc wheregrade>90 group by sno having count(*)>2
发布时间:2025-06-08 02:54:13