what is null ? unknown or missing values
-- null is not equal to zero or blank
select * from emps where deptno is null;
select * from emps where deptno is not null;
select * from emps where comm is null;
select * from emps where comm is not null;
Comments
Post a Comment