与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
A: WHERE AGE＞18AND AGE＜23
B: WHERE AGE＞＝18AND AGE＜23
C: WHERE AGE＞18AND AGE＜＝23
D: WHERE AGE＞＝18AND AGE＜＝23
举一反三
- 同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
- 查询年龄不在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
- 年龄在18～23岁之间的SQL条件语句除了用“WHERE AGE BETWEEN 18 AND 23”外，与其完全等价的还可以是。
- 表达式“AGE BETWEEN 18 AND 24”等价于 A: AGE>18 AND AGE<24 B: AGE>=18 AND AGE<24 C: AGE>18 AND AGE<=24 D: AGE>=18 AND AGE<=24
- 中国大学MOOC: 年龄在18～23岁之间的SQL条件语句除了用“WHERE AGE BETWEEN 18 AND 23”外，与其完全等价的还可以是 。