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

admin2010-07-20  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

答案B

解析
转载请注明原文地址:https://kaotiyun.com/show/qDvZ777K
0

最新回复(0)