以下( )语句可查询选修了三门以上成绩在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
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
举一反三
- 针对学生选课表sc(sno, cno, grade),其中sno为学号,cno为课程号,grade为成绩。以下( )语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select sno from sc where grade>90 group by sno having count(cno)>2; B: select sno from sc where grade>90 group by sno having count(*)>2; C: select sno from sc where grade>90 and count(*)>2 group by sno; D: select sno from sc where grade>90 group by sno having count(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
- 下列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
- 在学生选课数据库中,查询平均成绩大于等于60分的同学,SQL语句为( ) A: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING AVG(Grade)>=60; B: SELECT Sno FROM SC WHERE Grade>=60 GROUP BY Sno; C: SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG(Grade)>=60; D: SELECT Sno FROM SC GROUP BY Sno HAVING Grade >=60;
- 针对学生选课表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