• 2022-06-07 问题

    score表中存储了学生的学号、期末成绩,如果需要查询期末成绩在85-90之间的学生及成绩,以下可以实现的是( ) A: select studentno,final from score where final between 85 and 90; B: select studentno,final from score where final between 85 and 91; C: select studentno,final from score where final between 84 and 90; D: select studentno,final from score where final >=85 and finale<=90;

    score表中存储了学生的学号、期末成绩,如果需要查询期末成绩在85-90之间的学生及成绩,以下可以实现的是( ) A: select studentno,final from score where final between 85 and 90; B: select studentno,final from score where final between 85 and 91; C: select studentno,final from score where final between 84 and 90; D: select studentno,final from score where final >=85 and finale<=90;

  • 1