Oracle 练习 012

1. 题目

显示佣金为空并且部门号为 20 或 30 的雇员信息

点我看答案

select *
from emp e
where e.comm is null
 and (e.deptno = 20 or e.deptno = 30);

select *
from emp e
where e.comm is null and e.deptno in (20, 30);