( 3 2 )查询学生姓名及其所选修课程的课程号和成绩,正确的 SQL 语句是A ) SELECT S . SNAME , SC

19 查阅

( 3 2 )查询学生姓名及其所选修课程的课程号和成绩,正确的 SQL 语句是

A ) SELECT S . SNAME , SC.C# , GRADE FROM S WHERE S . S # = SC . S#

B ) SELECT S . SNAME , SC.C #, GRADE FROM SC WHERE S . S # = = SC . S#

C ) SELECT S . SNAME , SC.C# , GRADE FROM S , SC WHERE S . S# = SC . S#

D ) SELECT S . SNAME , SC.C# , GRADE FROM S , SC WHERE S .S# = SC . C#

参考答案:

C

计算机三级