针对学生选课表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;
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;
举一反三
- 在学生选课数据库中，查询平均成绩大于等于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;
- 查询最低成绩大于85分的学生学号和平均成绩,可以使用的查询语句是: 。 A: SELECT Sno, AVG(Grade) FROM SC HAVING MIN(Grade) > 85 GROUP BY Sno; B: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING MIN(Grade) > 85; C: SELECT Sno, AVG(Grade) FROM SC WHERE MIN(Grade) > 85 GROUP BY Sno; D: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno WHERE MIN(Grade) > 85;
- 检索选修了课程”C1”的学生中成绩最高的学生的学号，正确的SELECT语句为（ ） A: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >=ALL (SELECT Grade FROM SC WHERE Cno=’C1’); B: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN (SELECT Grade FROM SC WHERE Cno=’C1’); C: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE > ANY (SELECT Grade FROM SC WHERE Cno=’C1’); D: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >= (SELECT Grade FROM SC WHERE Cno=’C1’);
- 针对学生选课表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
- 关系SC(Sno，Cno，Grade)表示学号，课程号，成绩。现要查询最高分在91分以上的学生的学号和平均成绩，正确的语句是______。 A: SELECT Sno，MAX(Grade) FROM SC WHERE MAX(Grade)＞=91 GROUP BY Sno B: SELECT Sno，MAX(Grade) FROM SC GROUP RY Sno HAVING MAX(Grade)＞=91 C: SELECT Sno，MAX(Grade) FROM SC WHERE MAX(Grade)＞=91 ORDER BY Sno D: SELECT Sno，MAX(Grade) FROM SC GROUP BY Cno HAVING MAX(Grade)＞=91