oracle学习62-oracle之set运算符和练习

 

 

--创建表
create table emp01
as
select * from employees
where department_id in (70,80)
 
--
--创建表
create table emp02
as
select * from employees
where department_id in (80,90)

--查询 --并集
select * from employees
where department_id in (70,80)
union all
select * from employees
where department_id in (80,90)