问题
单项选择题
对于数据表:student(sno,sname,sex,age,grade),查询学习成绩为空的学生的学号和姓名,下面语句正确的是_______。
A.SELECT sno,sname FROM student WHERE grade=NULL
B.SELECT sno,sname FROM student WHERE grade IS NULL
C.SELECT sno,age FROM student WHERE grade IS NULL
D.SELECT sno,age FROM student WHERE grade=NULL
答案
参考答案:B
解析:[评析] A、D选项中,不能写成列名=NULL;C、D选项查询的字段不正确。