与下图中的SQL查询语句具有相同的查询功能的是( )。

admin2019-03-28 22

问题与下图中的SQL查询语句具有相同的查询功能的是( )。

选项 A、select C.Sname，S.CourseID，S.Score
From Score as C
Right Join Students as S On C.SCode=S.StudentID
B、Select C.Sname,S.CourseID,S.Score
From Score as C
Right Outer Join Student as S On C.Scode=S.StudentID
C、Select C.Sname, S.CourseID, S Score
From Score as C
Full Join Student as S On C.Scode=S.StudentID
D、Select C.Sname,S.CourceID,S.Score
From Score as C
Full Outer join Student as S On C.Scode=S.StudentID

答案A,B

解析

转载请注明原文地址:https://kaotiyun.com/show/kDpD777K

本试题收录于：北大青鸟S2题库北大青鸟认证分类