下列选项中,用于查询 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 表有姓名字段 name。若想查询所有姓“王”的学生,并且姓名由三个字符组成,则应使用的SQL 语句是
A. SELECT* FROM student WHERE name LIKE ‘王__’;
B. SELECT* FROM student WHERE name LIKE ‘王%_’;
C. SELECT* FROM student WHERE name LIKE ‘王%’;
D. SELECT* FROM student WHERE name =’王__’;
下列选项中,能够查询 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;
已知用户表 user 有字段 ct ,若想查询 ct 字段值为 NULL 的用户,则应使用的 SQL语句的是
A. SELLECT * FROM user WHERE ct = NULL ;
B. SELECT * FROM user WHERE ct link NULL ;
C. SELECT * FROM user WHERE ct = ‘NULL’ ;
D. SELECT * FROM user WHERE ct IS NULL ;