检索选修课程号为“D3”的学生中成绩最高的学生的学号，正确的SELECT语句是( )

admin2017-10-26 60

问题检索选修课程号为“D3”的学生中成绩最高的学生的学号，正确的SELECT语句是( )

选项 A、SELECT S#
  FROM SC
   WHERE C # =’D3’AND GRADE> =
   (SELECT GRADE FROM SC
         WHERE C# =’D3’) ;
B、SELECT S#
  FROM SC
WHERE C# =’D3’AND GRADE IN
      (SELECT GRADE FROM SC
         WHERE C# =’D3’) ;
C、SELECT S#
  FROM SC
WHERE C# =’D3’AND GRADE NOT IN
   (SELECT GRADE FROM SC
      WHERE C# =’D3’) ;
D、SELECT S#
FROM SC
   WHERE C # =’D3’AND GRADE> = ALL
   (SELECT GRADE FROM SC
         WHERE C# =’D3t) ;

答案D

解析

转载请注明原文地址:https://www.kaotiyun.com/show/5wkx777K

本试题收录于：数据库系统原理题库理工类分类