注意：此页面搜索的是所有试题
题目内容
（国家开放大学MySQL数据库应用）
员工表staff表结构如下
staffNo varchar2(10),
Email varchar2(50)
哪一个SQL语句能查询出没有E_mail地址的员工号（C ）
A. select staffno from Staff where Email = NULL
B. select staffno from Staff where Email <> NULL
C. select staffno from Staff where Email is null
D. select staffno from Staff where Email is not null
staffNo varchar2(10),
Email varchar2(50)
哪一个SQL语句能查询出没有E_mail地址的员工号（C ）
A. select staffno from Staff where Email = NULL
B. select staffno from Staff where Email <> NULL
C. select staffno from Staff where Email is null
D. select staffno from Staff where Email is not null
参考答案