SQL> select * from emp01;
EMP DEP NAME SALARY --- --- ---------- ---------- E01 D01 なまえ1 100 E02 D01 なまえ2 200 E03 D02 なまえ3 300 E04 D03 なまえ4 400
SQL> select * from emp02;
EMP DEP NAME SALARY --- --- ---------- ---------- E01 D01 なまえ1 100 E02 D01 なまえ2 200 E05 D05 なまえ5 500
SQL> select * from emp01 2 intersect 3 select * from emp02;
EMP DEP NAME SALARY --- --- ---------- ---------- E01 D01 なまえ1 100 E02 D01 なまえ2 200