( 3 2 )查询学生姓名及其所选修课程的课程号和成绩,正确的 SQL 语句是A ) SELECT S . SNAME , SC
18 查阅
( 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#
参考答案: