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

admin2019-03-28  17

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

选项 A、Select S.SName,C.CourseID,C.Score
From Students as S LEFT JOIN Score as C
On (S.SCOde=C.StudentID)
B、Select S.SName,C.CourseID,C.Score
From Students as S LEFT Outer JOIN Score as C
On (S.SCOde=C.StudentID)
C、Select S.SName,C.CourseID,C.Score
From Students as S INNER JOIN Score as C
On (S.SCOde=C.StudentID)
D、Select Students.SName,Score.CourseID,Score.Csore
From Students as S INNER JOIN Score
On (S.SCOde=C.StudentID)

答案A,B

解析
转载请注明原文地址:https://jikaoti.com/ti/lI0iFFFM
0

最新回复(0)