设S(S#,SNAME)、SC(S#，C#，G)分别为学生关系和选课关系，现要查询选修C2课程 (C#)，且成绩为B以上(含B) 的学生及成绩(G)，相应的SQL语句是： SELECTS.*，SC.GFROMS，SC WHERES.S#=SC.S# AND SC.C#='C2'AND______。 A: SC.G＞='B' B: SC.G＜='B' C: SC.G≥'B' D: SC．G≤'B&

现要从SC表中查找缺少学习成绩(G)的学生学号(S#)和课程号(C#)，正确的SQL是 A: SELECT S#，C# FROM SC WHERE G=0 B: SELECT S#，C# FROM SC WHERE G<=0 C: SELECT S#，C# FROM SC WHERE G=NULL D: SELECT S#，C# FROM SC WHERE G IS NULL

现要从SC表中查找缺少学习成绩(G)的学生学号(S#)和课程号(C#),正确的SQL是( ). A: SELECT S B: ,C C: FROM SC WHERE G=NULL D: SELECT S E: ,C F: FROM SC WHERE G IS NULL G: SELECT S H: ,C I: FROM SC WHERE G=0 J: SELECT S K: ,C L: FROM SC WHERE G&lt;=0

现要在SC（S#， C#， G）表中查找缺少成绩(G)的学生学号(S#)和课程号(C#)，下面SQL语句中WHERE子句的条件表达式应是： SELECT S#，C# FROM SC WHERE

已知表:SC(S#,C#,CRADE),其中S#、C#、CRADE分别代表学号、选修课号、成绩。则统计选修了课程的学生的总数的SQL语句应为: A: SELECT COUNT(DISTINCT S B: ) FROM SC C: SELECT COUNT(DISTINCT *) FROM SC D: SELECT COUNT(S E: ) FROM SC F: SELECT COUNT(DISTINCT C G: ) FROM SC

下列文法哪个是左递归的？ A: G[S]: S->aSb|a B: G[S]: S->Sa|a C: G[S]: S->aS|a D: G[S]: S->Ab|a A->Bb|c B->Sc|d

下列SQL语句中，正确的是（ ）。 A: SELECT S B: , SNAME FROM SC GROUP BY S C: SELECT S D: FROM SC GROUP BY S E: HAVING COUNT(*)>3 F: SELECT S G: ,Cname FROM SC GROUP BY S H: WHERE COUNT(*)>3 I: SELECT S J: FROM SC WHERE COUNT(*)>3 GROUP BY S

检索选修课程‘C2’的学生中成绩最高的学生的学号。正确的select语句为（ ）。 A: select S B: from sc where C C: =‘C2’and grade>= (select grade from sc where C D: =‘C2’) E: select S F: from sc where C G: =‘C2’and grade in (select grade from sc where C H: =‘C2’) I: select S J: from sc where C K: =‘C2’and grade not in (select grade from sc where C L: =‘C2’) M: select S N: from sc where C O: =‘C2’and grade>=all (select grade from sc where C P: =‘C2’)

检索选修“C2”课程的学生中成绩最高的学生的学号。正确的SELECT语句是（ ）。 A: SELECT s B: FROM sc WHERE c C: =’C2’ AND grade＞＝(SELECT grade FROM sc WHERE c D: =’C2’); E: SELECT s F: FROM sc WHERE c G: =’C2’ AND grade IN(SELECT grade FROM sc WHERE c H: =’C2’); I: SELECT s J: FROM sc WHERE c K: =’C2’ AND grade NOT IN(SELECT grade FORM sc WHERE c L: =’C2’); M: SELECT s N: FROM sc WHERE c O: =’C2’ AND grade＞＝(SELECT max(grade) FROM sc WHERE c P: =’C2’);

从键盘上输入数据的代码如下：Scanner sc=new Scanner( ...g s=sc. ();//输入一个字符串