一起答
单选

在学生表STUD中,查询年龄在20~23岁之间的学生的姓名(XM)、年龄(SA)和所在系(SD),实现该功能的正确SQL语句是______。

  • A.SELECT XM, SA, SD FROM STUD WHERE BETWEEN 20<SA<23;
  • B.SELECT XM, SA, SD FROM STUD WHERE SA BETWEEN 23 AND 20;
  • C.SELECT XM, SA, SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23;
  • D.SELECT XM, SA, SD FROM STUD WHERE SA BETWEEN 20 AND 23;
参考答案
查看试卷详情