在线名词解释大全 - 数据库题目 - 详细

检索学号为95020学生所学课程的课程名与任课教师名。

A
SELECT cname,teacher FROM S,SC WHERE S.s#=SC.s# AND s#='95020'
B
SELECT cname,teacher FROM S,SC,C WHERE S.s#=SC.s# AND SC.c#=C.c# AND s#='95020'
C
SELECT cname,teacher FROM SC,C WHERE SC.c#=C.c# AND s#='95020'
D
SELECT cname,teacher FROM S,SC,C WHERE s#='95020'
正确答案:
SELECT cname,teacher FROM S,SC,C WHERE S.s#=SC.s# AND SC.c#=C.c# AND s#='95020'
相关推荐
扫描二维码
关注公众平台