问题
单项选择题
对于学生信息表STUDENT(SNO,SNAME,SEX,AGE,DEPT) (STUDENT由学号SNO、姓名SNAME、性别SEX、年龄AGE、所在系DEPT5个属性组成,其中SNO为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是( )。
A.SELECT SNAME,AGE FROM STUDENT
WHERE AGE>20 AND AGE<23
B.SELECT*FROM STUDENT
WHERE AGE BETWEEN 20 AND 23
C.SELECTSNAME,AGE FROM STUDENT
WHERE AGE BETWEEN 20 AND 23
D.以上均不正确
答案
参考答案:C