单项选择题

假设表table1中有一个columns1字段中含有空值,请问,下列哪个语句能查询出来含有空值的行()

A.select *from table1where columns1=null;
B.select *from table1where columns1='';
C.select *from table1where columns1=‘’;
D.select *from table1where columns1is null;