Question

在SQL语句中要查询表s在AGE字段上取空值的记录,正确的SQL语句为

SELECT * FROM s WHERE_____

Answer 1

横线处填：age is null
完整语句：select * from s where age is null
记得采纳。

Answer 2

age =' ' 空白值
age is null 空值
试试

Answer 3

select * from s where age is null
一句就完事了。

Answer 4

SELECT * FROM s WHERE isnull(age,'')=''