A: SELECT*FROMstudentwhereid=1,2,3
B: SELECT*FROMstudentwhere(id=1,id=2,id=3)
C: SELECT*FROMstudentwhereidin(1,2,3)
D: SELECT*FROMstudentwhereidin1,2,3
举一反三
- 下面用于查询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值不在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;
- 下面选项中,查询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;
内容
- 0
在下列查询条件中,可以使用索引的是( )。 A: id + 2 > 3 B: id > 3 - 2 C: id + 1 = 3 D: id = 3
- 1
下面选项中,用于查询student表中id值在1,2,3范围内的记录的SQL语句是
- 2
写出条件查询“表1 里的字段1的id是多少”() A: select * from 表1 where字段1=“值” B: select id from 表1 where字段1=“值” C: select id from 字段1 where表1=“值” D: select id from 表1
- 3
假设某表有三个字段:列名1、列名2、列名3,要查询该表的所有记录,写法正确的是: A: SELECT *列名1,列名2,列名3,…… FROM 表名; B: SELECT 列名1,列名2,列名3,…… FROM 表名; C: SELECT 列名1,列名2,列名3FROM 表名; D: SELECT *FROM 表名; E: SELECT 列名3,列名2,列名1FROM 表名; F: SELECT 列名1列名2 列名3FROM 表名; G: SELECT 列名2,列名1,列名3FROM 表名; H: H. SELECT 列名1;列名2;列名3FROM 表名; I: I. SELECT 列名1、列名2、列名3FROM 表名; J: J. SELECT {列名1,列名2,列名3,……}FROM 表名; K: K. SELECT {列名1,列名2,列名3}FROM 表名; L: L. SELECT 列名1,列名3,列名2FROM 表名;
- 4
下面选项中,与“SELECT * FROM student where id not between 2 and 5;”等效的SQL是