• 2022-10-27
    在学生表STUD中,查询年龄在20至23岁之间的学生的姓名(XM)、年龄(SA)和所在系(SD),实现该功能的正确SQL语句是( )。
    A: SELECT XM,SA,SD FROM STUD WHERE BETWEEN 20B.SELECT XM,SA,SD.FROM STUD WHERE SA BETWEEN 23 AND 20
    B: SELECT XM,SA,SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23
    C: SELECT XM,SA,SD FROM STUD WHERE SA BETWEEN 20 AND 23
  • 举一反三