有学生信息表student，求年龄在20岁到22岁之间（含20岁和22岁)的学生姓名和年龄的 SQL语句是： SELE

有学生信息表student，求年龄在20～22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是

SELECT sname，age FROM student

WHERE age【 】；

A.＞20 and age＜22

B.BETWEEN 20 AND 22

C.＞=20 and age＜22

D.＞20 and age＜=22

A.＞20 and age＜22

B.BETWEEN 20 AND 22

C.＞=20 and age＜22

D.＞20 and age＜=22

对于学生信息表：student(sno，sname，sex，age，dept)，能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是

A．SELECT * FROM student WHERE age BETWEEN 20 AND 22

B．SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22

C．SELECT sname，sno FROM student WHERE age＞=20

D．SELECT sname，sno FROM student WHERE age＜=22

对于学生信息表:student(sno, sname, sex, age, dept）,能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是

A．SELECT * FROM student WHERE age BETWEEN 20 AND 22

B．SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22

C．SELECT sname,sno FROM student WHERE age＞= 20

D．SELECT sname,sno FROM student WHERE age＜= 22

对于学生信息表：student(sno，sname，sex，age，dept)，能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是

A．SELECT * FROM student WHERE age BETWEEN 20 AND 22

B．SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22

C．SELECT sname，sno FROM student WHERE age＞=20

D．SELECT sname，sno FROM student WHERE age＜=22

所在系DEPT 5个属性组成，其中SNO为主码），求年龄20～23岁之间的学生姓名和年龄，正确的语句是（）。A．SELECT SNAME，AGE FROM STUDENT WHERE AGE＞20 AND AGE＜23B． SELECT*FROM STUDENT WHERE AGE BETWEEN 20 AND 23C．SELECT SNAME，AGE FROM STUDENT WHERE AGE BETWEEN 20 AND 23D．以上均不正确

对于学生信息表S(SNUMBER，SNAME，SEX，AGE，DEPT)(STUDENT 由学号 SNO，姓名SNAME，性别SEX，年龄AGE，所在系DEPT5个属性组成，其中SNUMBER为主码)，求年龄20～23岁之间的学生姓名和年龄，正确的语句是()。

A．SELECT SNAME，AGE FROM S WHERE AGE＞20 AND 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) 以上均不正确

A．SELECT Sname,Sage FROM Student WHERE Sage<=20;

B．SELECT Sname,Sage FROM Student WHERE NOT Sage<20;

C．SELECT Sname,Sage FROM Student WHERE NOT Sage>20;

D．SELECT Sname,Sage FROM Student WHERE Sage<20;