is null :判断为null
is not :判断不为null
需求:查询奖金率为null的员工信息
select * from employees where commission_pct is null;
需求:查询有奖金率的员工信息
select * from employees WHERE commission_pct is not null;
is null :判断为null
is not :判断不为null
需求:查询奖金率为null的员工信息
select * from employees where commission_pct is null;
需求:查询有奖金率的员工信息
select * from employees WHERE commission_pct is not null;