单选题
在学生表STUD中,查询年龄在20至23岁之间的学生的姓名(XM),年龄(SA)和所在系(SD),实现该功能的正确SQL语句是{{U}}
{{/U}}。
- A.SELECT XM, SA, SD FROM STUD
WHERE BETWEEN 20<SA<23
- B.SELECTXM, SA, SD FROM
STUD WHERE SA BETWEEN 23
AND 20
- C.SELECTXM, SA, SD FROM
STUD WHERE SA NOTBETWEEN20
AND 23
- D.SELECTXM, SA, SD FROM
STUD WHERE SA BETWEEN 20
AND 23