同WHERE Age BETWEEN 15 AND 20完全等价的是（ ）。
A: WHERE Age>;15 AND Age<;20
B: WHERE Age>;=15 AND Age<;20
C: WHERE Age>;15 AND Age<;=20
D: WHERE Age>;=15 AND Age<;=20
A: WHERE Age>;15 AND Age<;20
B: WHERE Age>;=15 AND Age<;20
C: WHERE Age>;15 AND Age<;=20
D: WHERE Age>;=15 AND Age<;=20
举一反三
- 与WHERE AGE BETWEEN 18 AND 23完全等价的是（） A: WHERE AGE＞18AND AGE＜23 B: WHERE AGE＞＝18AND AGE＜23 C: WHERE AGE＞18AND AGE＜＝23 D: WHERE AGE＞＝18AND AGE＜＝23
- 下面 语句和”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);
- 查询年龄不在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
- 查看年龄为20的所有人的记录，SQL语句为（） A: SELECT * FROM CUSTOMERS WHERE AGE=20 B: DROP FROM CUSTOMERS WHERE AGE=20 C: SELECT FROM CUSTOMERS WHERE AGE=20 D: DELETE FROM CUSTOMERS WHERE CUSTID=5
- 对于学生信息表：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