将SC和Student表连接起来，显示学生的学号、姓名、课程号、考试分数，不正确的SQL语句是( )。 A: Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC,StudentWhere SC.Sno=Student.Sno B: Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC Join StudentOn SC.Sno=Student.Sno C: Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom Student Join SC On SC.Sno=Student.Sno D: Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC,StudentOn SC.Sno=Student.Sno

‎将SC和Student表连接起来，显示学生的学号、姓名、课程号、考试分数，不正确的SQL语句是( )。‍ A: Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC,StudentWhere SC.Sno=Student.Sno B: Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC Join StudentOn SC.Sno=Student.Sno C: Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom Student Join SC On SC.Sno=Student.Sno D: Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC,StudentOn SC.Sno=Student.Sno

查询计算机系任意学生选修过的课程号，不正确的查询语句是： A: SELECT DISTINCT CnoFROM SCWHERE NOT EXISTS (SELECT SnoFROM StudentWHERE Sdept = 'CS'AND SSno = Student.Sno); B: SELECT DISTINCT CnoFROM SCWHERE EXISTS (SELECT SnoFROM StudentWHERE Sdept = 'CS'AND SSno = Student.Sno); C: SELECT DISTINCT CnoFROM SCWHERE Sno IN (SELECT SnoFROM StudentWHERE Sdept = 'CS'); D: SELECT DISTINCT CnoFROM SCLEFT JOIN StudentON SSno = Student.SnoWHERE Sdept = 'CS';

查询计算机系任意学生选修过的课程号，不正确的查询语句是： A: SELECT DISTINCT CnoFROM SCWHERE NOT EXISTS (SELECT SnoFROM StudentWHERE Sdept = 'CS'AND SC.Sno = Student.Sno); B: SELECT DISTINCT CnoFROM SCWHERE EXISTS (SELECT SnoFROM StudentWHERE Sdept = 'CS'AND SC.Sno = Student.Sno); C: SELECT DISTINCT CnoFROM SCWHERE Sno IN (SELECT SnoFROM StudentWHERE Sdept = 'CS'); D: SELECT DISTINCT CnoFROM SCLEFT JOIN StudentON SC.Sno = Student.SnoWHERE Sdept = 'CS';

查询每个学生及其选修课程的情况(不包括没有选修课程的学生),以下语句正确的为()(SQLSERVER平台中) A: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentrightjoinscon(student.sno=sc.sno) B: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentleftjoinscon(student.sno=sc.sno) C: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentrightoutjoinscon(student.sno=sc.sno) D: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM scleft outjoin Studenton(student.sno=sc.sno)