检索学生姓名及其所选修课程的课程号和成绩。正确的SELECT 语句是
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
查看答案
正确答案: C 答案分析:无
包含此试题的试卷:
相关的试题
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.
A.SELECT S.SN,SC.C#,SC.CRADE FROMS WHERE S .S#=SC.S#
B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S .S#=SC.CRADE
C.SELECT S.SN,SC.C#,SC.CRADE FROM S ,SC WHERE S .S#:SC.S#
D.SELSECT S.SN,SC.C#,SC.