itgle.com

“SELECT * FROM Student INNER JOIN SCON Student.Sno = SC.Sno ”语句可将 Student 与 SC连接起来。( )此题为判断题(对，错)。

题目
“SELECT * FROM Student INNER JOIN SCON Student.Sno = SC.Sno ”语句可将 Student 与 SC连接起来。( )

此题为判断题(对，错)。

相似考题

1.已知有关系“STUDENT”，则关系运算σANE＜80(STUDENT)用SQL语句表示为(52)。A．SELECT( * )FROM STUDENT WHERE AVE ＜ 80B．SELECT( * )FROM STUDENT HAVING AVE ＜ 80C．SELECT(AVE)FROM STUDENT WHERE AVE ＜ 80D．SELECT(AVE） FROM STUDENT HAVING AVE ＜ 80

2.从学生表student查询学生的所有信息，正确的语句是______。A．SELECT # FROM studentB．SELECT * FROM studentC．SELECT ？ FROM studentD．SELECT _ FROM student

3.以下（）操作实现了student表与sc之间的自然连接。A．select student.* , sc.* from student , sc where student.sno=sc.snoB．select student.* , cno, grade from student , sc where student.sno=sc.snoC．select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.snoD．select student.* , cno, grade from student join sc on student.sno=sc.sno

4.SELECT *  FROM  Student  INNER JOIN  SC ON Student.Sno = SC.Sno语句可将Student与 SC连接起来。A对B错

更多““SELECT * FROM Student INNER JOIN SCON Student.Sno = SC.Sno ”语句可将 Student 与 SC连接起来。( ) ”相关问题

  • 第1题：

    下面的SQL语句也可以用带Join关键词的语句来实现。 Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.Sno


    正确

  • 第2题：

    9、将SC和Student表连接起来，显示学生的学号、姓名、课程号、考试分数，不正确的SQL语句是（)。

    A．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.Sno

    B．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.Sno

    C．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.Sno

    D．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno


    Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno

  • 第3题：

    以下（）操作实现了student表与sc之间的自然连接。

    A．select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.sno

    B．select student.* , sc.* from student , sc where student.sno=sc.sno

    C．select student.* , cno, grade from student , sc where student.sno=sc.sno

    D．select student.* , cno, grade from student join sc on student.sno=sc.sno


    select student.* , cno, grade from student , sc where student.sno=sc.sno;select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.sno;select student.* , cno, grade from student join sc on student.sno=sc.sno

  • 第4题：

    将SC和Student表连接起来，显示学生的学号、姓名、课程号、考试分数，不正确的SQL语句是（)。

    A．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.Sno

    B．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.Sno

    C．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.Sno

    D．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno


    Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno

  • 第5题：

    4、以下内连接的语法格式正确吗？ select ＜列名列表＞ from ＜子表＞ [Inner] join ＜父表＞ on ＜子表.外键＞ = ＜父表.主键＞


    SELECT 查询字段 FROM 表1 [INNER] JOIN 表2 ON 表1.关系字段 = 表2.关系字段

相关内容