下面的SQL语句也可以用带Join关键词的语句来实现。Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC,StudentWhere SC.Sno=Student.Sno
A: 正确
B: 错误
A: 正确
B: 错误
举一反三
- 将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
- 下面的SQL语句也可以用带Join关键词的语句来实现。Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC,StudentWhere SC.Sno=Student.Sno
- 下面的SQL语句也可以用带Join关键词的语句来实现。Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC,StudentWhere SC.Sno=Student.Sno A: 正确 B: 错误
- 下面的SQL语句也可以用带Join关键词的语句来实现。Select Student.Sno,Student.Sname, SC.Cno,SC.GradeFrom SC,StudentWhere SC.Sno=Student.Sno
- 在学生选课数据库中，查询选修了课程的学生的学号、姓名，SQL语句可为（ ） A: SELECT DISTINCT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno; B: SELECT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno; C: SELECT DISTINCT Sno, DISTINCT Sname FROM Student WHERE Student.Sno IN (SELECT Sno FROM SC); D: SELECT Sno, Sname FROM Student WHERE Student.Sno IN (SELECT DISTINCT Sno FROM SC);