问题
单项选择题
在学生表STUD中,查询年龄在20至23岁之间的学生的姓名(xm),年龄(SA)和所在系(SD),实现该功能的正确SQL语句是( )。
A.SELECTXM, SA, SD FROM STUDWHERE BETWEEN 20<SA<23
B.SELECTXM, SA, SD FROM STUDWHERE SA BETWEEN 23 AND 20
C.SELECTXM, SA, SD FROM STUDWHERE SA NOTBETWEEN20 AND 23
D.SELECTXM, SA, SD FROM STUDWHERE SA BETWEEN 20 AND 23
答案
参考答案:D