(40)查找学生姓名及其所选修课程号和成绩,正确的 SQL 语句是 A)SELECT sname FROM student, SEL
(40)查找学生姓名及其所选修课程号和成绩,正确的 SQL 语句是
A)SELECT sname FROM student, SELECT cno,grade FROM sc WHERE student.sno =sc.sno
B) FROM sname,cno,grade FROM student,course WHERE student.sno =course.cno
C) SELECT sname ,canme,grade FROM student,course,sc WHERE student.sno =sc.sno and sc.c
no=course.cno
D) SELECT sname ,cno,grade FROM student,sc WHERE student.sno =sc.sno
(40)【答案】C)
【解析】题意中要求查找学生姓名。课程号的成绩。这一个属性可以查找两个关系表
student 和 se,通过条件 student,so=sc.so 进行连接。
i was a student one year ago.(变成一般疑问句)( )( )a stu 英语 2020-05-14 …
怎么把下列句子用and变为并列句,1.l am form china,l am chinese 2 英语 2020-05-14 …
he says:"If he calls me,I will go." he says:"I he 英语 2020-05-16 …
(1)I don't think she has finished her homework.(变 英语 2020-05-16 …
The teacher said to a student,"Please pass the bo 英语 2020-05-16 …
同义转换He is no more a student.he()a student() 英语 2020-05-16 …
My sister is a student,I am a student合并成一句话:my si 英语 2020-05-16 …
英语问题(选择题+翻译+句型转换)一.选择.1.Tom ____ a student.A.may 英语 2020-05-16 …
so的倒装句就近一致问题!he is a student and likes english.so 其他 2020-05-16 …
she is student.错哪了.为什么一定是 she is a student 英语 2020-05-17 …