下面选项中,查询stu表中id值不在2和5之间的学生的SQL语句是( )。 A: select * from stu where id != 2,3,4,5; B: select * from stu where id not betwen 5 and 2; C: select * from stu where id not betwen 2 and 5; D: select * from stu where id not in 2,3,4,5;

公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！

2022-06-15

下面选项中,查询stu表中id值不在2和5之间的学生的SQL语句是( )。 A: select * from stu where id != 2,3,4,5; B: select * from stu where id not betwen 5 and 2; C: select * from stu where id not betwen 2 and 5; D: select * from stu where id not in 2,3,4,5;

下面选项中,查询stu表中id值不在2和5之间的学生的SQL语句是( )。
A: select * from stu where id != 2,3,4,5;
B: select * from stu where id not betwen 5 and 2;
C: select * from stu where id not betwen 2 and 5;
D: select * from stu where id not in 2,3,4,5;

答案：

查看

举一反三

下面选项中，查询student表中id值不在2和5之间的SQL语句是（）。 A: SELECT * FROM `student` WHERE `id`!=2,3,4,5 B: SELECT * FROM `student` WHERE `id` NOT BETWEEN 5 AND 2 C: SELECT * FROM `student` WHERE `id` NOT BETWEEN 2 AND 5 D: SELECT * FROM `student` WHERE `id` NOT IN 2,3,4,5
下面选项中,查询student表中id值不在2和5之间的学生的SQL语句是 A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;
下面选项中,查询student表中id值不在2和5之间的学生,其中正确的SQL语句是() A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;
下面用于查询student表中id值在1,2,3范围内的记录的SQL语句是（）。 A: SELECT * FROM student WHERE id=1,2,3; B: SELECT * FROM student WHERE (id=1,id=2,id=3); C: SELECT * FROM student WHERE id in (1,2,3); D: SELECT * FROM student WHERE id in 1,2,3;
查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是() A: SELECT name FROM student WHERE id<;5 OR gender='女'; B: SELECT name FROM student WHERE id<;5 AND gender='女'; C: SELECT name FROM student WHERE id<;5 ,gender='女'; D: SELECT name FROM student WHERE id<;5 AND WHERE gender='女';