查询年龄不在20到23岁之间的学生的信息，所使用的语法命令为（）
A: select * from student where age not between 20 and 23
B: select * from student where age between 20 and 23
C: select * from student where age not between 20 to 23
D: select * from student where not age from 20 to 23
A: select * from student where age not between 20 and 23
B: select * from student where age between 20 and 23
C: select * from student where age not between 20 to 23
D: select * from student where not age from 20 to 23
举一反三
- 查询年龄在20到23岁之间的学生的信息，所使用的语法命令为（） A: select * from student where age between 20 to 23 B: select * from student where age from 20 to 23 C: select * from student where age between 20 and 23 D: select * from student
- 下面 语句和”select * from student where sex=’男’ && age=20;”语句查询出的结果是一样的。（ ） A: select * from student where sex=’男’ or age=20; B: select * from student where sex=’男’ || age=20; C: select * from student where sex=’男’ and age=20; D: select * from student where sex,age in(’男’,20);
- 对于学生信息表：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，有列Name，Age，IDCard，Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据，下列哪个SQL语句是正确的？（） A: Select* From Student Where Age>=20 ANDAge>=30 B: Select* From Student Where Age>=20 ANDAge<=30 C: Select* From Student Where Age BET WENN 20AND30 D: Select* From Student Where Age>=20&&Age>=30"
- 在学生表STUD中，查询年龄在20～23岁之间的学生的姓名(XM)、年龄(SA)和所在系(SD)，实现该功能的正确SQL语句是______。 A: SELECT XM, SA, SD FROM STUD WHERE BETWEEN 20＜SA＜23; B: SELECT XM, SA, SD FROM STUD WHERE SA BETWEEN 23 AND 20; C: SELECT XM, SA, SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23; D: SELECT XM, SA, SD FROM STUD WHERE SA BETWEEN 20 AND 23;