A: WHERE name ! NULL
B: WHERE name NOT NULL
C: WHERE name IS NOT NULL
D: WHERE name!=NULL
举一反三
- 查找条件为：姓名字段NAME不是NULL的记录()。 A: WHERE NAME ! NULL B: WHERE NAME NOT NULL C: WHERE NAME IS NOT NULL D: WHERE NAME!=NULL
- 【】语句是查找条件为：姓名不是NULL的记录。 A: WHERE NAME IS NOT NULL B: WHERE NAME !=NULL C: WHERE NAME NOT NULL D: WHERE NAME ! NULL
- 【单选题】查找:姓名不为空的记录,SELECT语句的条件子句正确的是()。 A. WHERE NAME !NULL B. WHERE NAME NOT NULL C. WHERE NAME IS NOT NULL D. WHERE NAME !=NULL
- 下列语句正确的是( ?) A: WHERE NAME NULL B: WHERE NAME IS NULL C: WHERE NAME=NULL D: WHERE NAME ==NULL
- 若想查询student表中name为空值的记录，则正确的SQL语句是（ ）。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;
内容
- 0
若想查询student表中name为空值的记录，则正确的SQL语句是（1.0分） A: select * from student where name = null; B: select * from student where name link null; C: select * from student where name = 'null'; D: select * from student where name is null;
- 1
下面哪一个语句,显示没有Email地址的教师姓名() A: Select name from teacher where email=NULL; B: Select name from teacher where email C: Select name from teacher where email is NULL; D: Select name from teacher where emailis not NULL;
- 2
在Oracle中，有一个教师表teacher的结构如下： 下面哪个语句显示没有Email地址的教师的姓名（）。 A: select name from teacher where email=null B: select name from teacher where email<>null C: select name from teacher where email is null D: select name from teacher where email is not null
- 3
使用SQLiteDatabase对象db，从user表中查找name为tom的记录，使用的语句为： A: db. query("user",null,"name=?",new String[]{"tom"},null,null,null) B: db. query("user",null,"name",new String[]{"tom"},null,null,null) C: db. query("user",null,"name=?",new String[]{tom},null,null,null) D: db. query("user",null,"name=tom",null,null,null,null)
- 4
判断值是否为NULL，采用 where 表达式 is NULL 表示，判断值不为NULL，where表达式为 !=NULL？