一起答
单选

( 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#
参考答案
查看试卷详情