一、并集union all 与 合集union
1.在使用union all时字段对应缺失的可以用null来代替;
2.在使用union时,会把重复的数据去掉
eg:select deptno
from
(select empno,deptno from emp where mgr = 7698
union
select empno,deptno from where job = 'salesman')
order by 1;
结果:加入唯一键empno防止不该发生的去重
eg:select deptno
from
(select ROWID,deptno from emp where mgr = 7698
union
select 多表操作.note,deptno from where job = 'salesman')
order by 1;
结果:除了用唯一列、主键,还可以使用rowid