如果想限制sc(sno,cno,grade)表中每人最多选三门课，如何用断言表示？sc(sno,cno,grade)表示选修（学号，课程号，成绩）
A: Create assertion asse1 check(3>=all( select count(*) from sc group by sno))
B: Create assertion asse1 check(3>=any( select count(*) from sc group by sno))
C: Create assertion asse1 check(3>=some( select count(*) from sc group by sno))
D: Create assertion asse1 check(3>= select count(*) from sc group by sno)
A: Create assertion asse1 check(3>=all( select count(*) from sc group by sno))
B: Create assertion asse1 check(3>=any( select count(*) from sc group by sno))
C: Create assertion asse1 check(3>=some( select count(*) from sc group by sno))
D: Create assertion asse1 check(3>= select count(*) from sc group by sno)
举一反三
- 针对学生选课表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， COUNT（*） FROM SC GROUP BY Sno B: SELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*）> 3 C: SELECT Sno FROM SC GROUP BY Sno HAVING COUNT（*）> 3 D: SELECT Sno FROM SC GROUP BY Sno
- 若要求“查询选修了3门以上课程的学生的学号”,正确的SQL语句是( ) A: SELECT sNo FROM SC GROUP BY sNo WHERE COUNT(*)> 3 B: SELECT sNo FROM SC GROUP BY sNo HAVING COUNT(*)> 3 C: SELECT sNo FROM SC ORDER BY sNo WHERE COUNT(*)> 3 D: SELECT sNo FROM SC ORDER BY sNo 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;
- 检索选修了课程”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’);