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