网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
“SELECT * FROM Student INNER JOIN SCON Student.Sno = SC.Sno ”语句可将 Student 与 SC连接起来。( )
此题为判断题(对，错)。
参考答案
更多 “ “SELECT * FROM Student INNER JOIN SCON Student.Sno = SC.Sno ”语句可将 Student 与 SC连接起来。( ) 此题为判断题(对，错)。 ” 相关考题
考题
已知有关系“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
考题
从学生表student查询学生的所有信息，正确的语句是______。A．SELECT # FROM studentB．SELECT * FROM studentC．SELECT ？ FROM studentD．SELECT _ FROM student
考题
以下（）操作实现了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
考题
下面的SQL语句也可以用带Join关键词的语句来实现。 Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.Sno
考题
将SC和Student表连接起来，显示学生的学号、姓名、课程号、考试分数，不正确的SQL语句是（)。A．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.SnoB．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.SnoC．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.SnoD．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno
考题
9、将SC和Student表连接起来，显示学生的学号、姓名、课程号、考试分数，不正确的SQL语句是（)。A．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.SnoB．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.SnoC．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.SnoD．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno
考题
以下（）操作实现了student表与sc之间的自然连接。A．select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.snoB．select student.* , sc.* from student , sc where student.sno=sc.snoC．select student.* , cno, grade from student , sc where student.sno=sc.snoD．select student.* , cno, grade from student join sc on student.sno=sc.sno
热门标签
最新试卷