SQL> select distinct deptno from dept
DEPTNO
----------
10
20
30
40
4 rows selected.
SQL> select distinct deptno from emp
DEPTNO
----------
30
20
10
3 rows selected.
SQL> select distinct deptno from dept
where deptno in
(select distinct deptno from emp)
DEPTNO
----------
30
20
10
3 rows selected.
SQL> select distinct deptno from dept
where exists
(select distinct deptno from emp where dept.deptno = emp.deptno)
DEPTNO
----------
30
20
10
3 rows selected.
SQL> select distinct deptno from dept
minus
select distinct deptno from emp
DEPTNO
----------
40
1 row selected.
SQL> select distinct deptno from dept
where deptno not in
(select distinct deptno from emp)
DEPTNO
----------
40
1 row selected.
SQL> select distinct deptno from dept
where not exists
(select distinct deptno from emp where dept.deptno = emp.deptno)
DEPTNO
----------
40
1 row selected.
| 
转播
