A.SELECT S# FROM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FROM SC WHERE C#="C2")
B.SELECT S# FROM SC WHERE C#="C2" AND GRADE IN(SELECT GRADE FROM SC WHERE C#="C2")
C.SELECT S# FROM SC WHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#="C2")
D.SELECT S# FROM SC WHERE C#="C2" AND GRADE> =ALL(SELECT GRADE FROM SC WHERE C#="C2")
[单选题]检索选修课程"C2”的学生中成绩最高的学生的学号,正确的SELECT语句是______。A.SELECT S# FORM. SC WHERE C#="C2"AND GRADE>=(SELECT GRADE FORM. SC WHERE C#="C2")B.SELECT S# FORM. SC WHERE C#="C2"AND GRADE IN(SELECT GRADE FORM. SC) WHERE C#="C2"C.SELECT S# FORM. SC WHERE C#="
[单选题]检索学生姓名及其所选修课程的课程号和成绩,正确的SELECT语句是______。A.SELECT S.SN,SC.C#,SC.GRADE FROMS WHERE S.S#=SC.S#B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADEC.SELECT S.SN,SC.C#,SC,GRADE FROM S,SC WHERE S.S#:SC.S#D.SELSECT S.SN,SC.C#,SC.GRADE FROM S,SC
[单选题]检索学生姓名及其所选修课程的课程号和成绩。正确的SELECT语句是______。A.SELECT S.SN,SC.C#,SC.GRADE FROM S WHERE S.S#=SC.S#B.SELECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADEC.SELECT S.SN, SC.C#,SC.GRADE FROM S,SC WHERE S.S#=SC.S#D.SELECT S.SN,SC.C#,SC.GRADE FROM S,SC
[单选题]设有学生选课表SC(学号,课程号,成绩),用SQL检索同时选修课程号为“C1”和“C5”的学生的学号的正确命令是( )。A.SELECT学号RORM
[单选题]设有学生选课表SC(学号,课程号,成绩),用SQL检索同时选修课程号为“C1”和“C5”的学生的学号的正确命令是______。A.SELECT 学号 FROM SC WHERE 课程号='C1' AND 课程号='C5'B.SELECT 学号 FROM SC WHERE 课程号='C1' AND 课程号=(SELECT 课程号 FROM SC WHERE 课程号='C5')C.SELECT 学号 FROM SC WHERE 课程号='C1' AND 学号=(SELECT 学号
[单选题]用SQL语句检索选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是( )。
[单选题]用SQL语句检索选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是( )。A.)SELECT S.学号,姓名,平均成绩FROM S,SC;WHERE S.学号=SC.学号;G.ROUP BY S.学号HAVING COUNT(﹡)>=5 0RDER BY平均成绩DESCB.)SELECT学号,姓名,AVG(成绩)FROM S,SC;WHERE S.学号=SC.学号AND COUNT(﹡)>=5;G.ROUPBY学号ORDERBY 3 DESC
[试题]检索选修课程包含学号为2且年龄小于20的学生所修全部课程的课程号。
[单选题]检索“至少选修课程号为′C1′的学生姓名(SNAME) ”的SQL语句是A.SELECT s.sname FROM s,sc WHERE c.cno=′C1′B.SELECT s.sname FROM s,sc WHERE c.cno=′C1′AND s.sno=sc.snoC.SELECT s.sname FROM s,sc FOR c.cno=′C1′D.SELECT s.sname FROM s,sc FOR c.cno=′C1′AND s.sno=sc.sno
[单选题]( 3 2 )查询学生姓名及其所选修课程的课程号和成绩,正确的 SQL 语句是A. ) SELECT S . SNAME , SC.C# , GRADE FROM S WHERE S . S # = SC . S#B. ) SELECT S . SNAME , SC.C #, GRADE FROM SC WHERE S . S # = = SC . S#C. ) SELECT S . SNAME , SC.C# , GRADE FROM S , SC WHERE S . S# = SC . S#