下列语句错误的是（) A.select * from orders where ordername is not null; B.select

下列语句错误的是()

A.select * from orders where ordername is not null;

B.select * from orders where ordername<>null;

C.select * from orders where ordername is null;

D.select * from orders where ordername not is null;