题目内容

查询所有未达60分的选课记录，要求显示出该学生的姓名、该门课程的名称和分数，不正确的查询语句是：（）

A. SELECT Student.Sname, Course.Cname, SC.GradeFROM SC, Student, CourseWHERE SC.Sno = Student.SnoAND SC.Cno = Course.CnoAND SC.Grade < 60;B.SELECT Student.Sname, Course.Cname, SC.GradeFROM StudentLEFT JOIN SCON SC.Sno = Student.SnoLEFT JOIN CourseON SC.Cno = Course.CnoWHERE SC.Grade < 60;
B. SELECT Student.Sname, Course.Cname, SC.GradeFROM SCLEFT JOIN StudentON SC.Sno = Student.SnoLEFT JOIN CourseON SC.Cno = Course.CnoWHERE SC.Grade < 60;
C. SELECT Student.Sname, Course.Cname, SC.GradeFROM StudentLEFT JOIN SCON SC.Sno = Student.SnoLEFT JOIN CourseON SC.Cno = Course.CnoWHERE SC.Grade < 60;
D. SELECT Student.Sname, Course.Cname, SC.GradeFROM CourseLEFT JOIN SCON SC.Cno = Course.CnoLEFT JOIN StudentON SC.Sno = Student.SnoAND SC.Grade < 60;

查看答案

搜索结果不匹配？点我反馈

更多问题

查询所有选修了数学（课程号为2）的学生姓名，不正确的查询语句是：（）

A. SELECT Student.SnameFROM Student, SCWHERE Student.Sno = SC.SnoAND SC.Cno = 2;
B. SELECT Student.SnameFROM StudentLEFT JOIN SCON Sno = Student.SnoWHERE SC.Cno = 2;
C. SELECT Student.SnameFROM StudentWHERE Sno In (SELECT SnoFROM SCWHERE Cno = 2);
D. SELECT SnameFROM SCLEFT JOIN StudentON Student.Sno = SC.SnoWHERE SC.Cno = 2;

查看答案