select * from emp;
--查询comm为null的员工信息
select * from emp where comm is null;
--查询comm不为null的员工信息
select * from emp where comm is not null;