题目内容

下列选项中,能够查询 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 ;

下列选项中,代表匹配单个字符的通配符是

A. %
B. *
C. _
D. ?

下列选项中,与“SELECT* FROM student WHERE id not between 2 and 5;”等效的 SOL 语句是注: id 的数据类型是整型。

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 in (2,3,4,5);
D. SELECT * FROM student WHERE id NOT in 2,3,4,5;

已知某数据表有姓名字段,如果查找姓“王”且姓名是两个字的用户,则应该使用

A. LIKE "王%"
B. LIKE "王_"
C. LIKE "王__"
D. LIKE "%王%”

答案查题题库