以下()语句可查询选修了三门以上成绩在80分以上课程的学生学号。
A: select snofromscwhere grade>80groupbysnohavingcount(cno)>3
B: select snofromscwhere grade>80groupbysnohavingcount(*)>3
C: select snofromscwhere grade>80 and count(*)>3groupbysno
D: elect snofromscwhere grade>80groupbysnohavingcount(sno)>3
A: select snofromscwhere grade>80groupbysnohavingcount(cno)>3
B: select snofromscwhere grade>80groupbysnohavingcount(*)>3
C: select snofromscwhere grade>80 and count(*)>3groupbysno
D: elect snofromscwhere grade>80groupbysnohavingcount(sno)>3
举一反三
- 下列SQL语句中，_____________可以在“学生-课程”数据库正确实现“查询选修并成绩良好3门以上课程的学生学号及其满足条件的课程门数”。 A: SELECT Sno，COUNT(*)FROM SCGROUP BY SnoHAVING Grade>=80 AND COUNT(*) >3 B: SELECT Sno，COUNT(*)FROM SCWHERE Grade>=80GROUP BY SnoHAVING COUNT(*) >3 C: SELECT Sno，COUNT(*)FROM SCGROUP BY SnoWHERE Grade>=80HAVING COUNT(*) >3 D: SELECT Sno，COUNT(*)FROM SCGROUP BY SnoWHERE Grade>=80 AND HAVING COUNT(*) >3
- 针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（）语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select snofrom scwhere grade>;90group by snohaving count(cno)>;2 B: select snofrom scwhere grade>;90group by snohaving count(*)>;2 C: select snofrom scwhere grade>;90 and count(*)>;2group by sno D: select snofrom scwhere grade>;90group by snohaving count(distinct sno)>;2
- 针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（ ）语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select sno from scwhere grade>90group by snohaving count(cno)>2 B: select sno from scwhere grade>90group by snohaving count(*)>2 C: select sno from scwhere grade>90 and count(*)>2group by sno D: select sno from scwhere grade>90group by snohaving count(sno)>2
- 查询编号为'c01'的课程考试成绩在80-89之间的学生的学号,下列（）语句不能实现。 A: select sno ,grade from sc where cno='c01' and grade between 80 and 89 B: select sno ,grade from sc where cno='c01' and grade>=80 and grade<90 C: select sno ,grade from sc where cno='c01' and not (grade90) D: select sno ,grade from sc where cno='c01' and grade in (80-89)
- 以下（ ）语句可查询选修了三门以上成绩在80分以上课程的学生学号。 A: select sno from scwhere grade>80group by snohaving count(cno)>3 B: select sno from scwhere grade>80group by snohaving count(*)>3 C: select sno from scwhere grade>80 and count(*)>3group by sno D: select sno from scwhere grade>80group by snohaving count(sno)>3