【名词&注释】
正确答案:B。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.以上均不正确 更多计算机三级的考试资料下载及答案解析请访问不凡考网计算机类考试考试频道。
[单选题]对于学生信息表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. 以上均不正确