union 会把查询结果一样的合并为一条
union all 不会合并 会独立编程两条记录
例子:
select 111 as abc,
222 as bcd
from dual
--会合并相同的记录
union
select 333 as abc,
444 as bcd
from dual
--不会合并相同的记录
union all
select 333 as abc,
444 as bcd
from dual
union 会把查询结果一样的合并为一条
union all 不会合并 会独立编程两条记录
例子:
select 111 as abc,
222 as bcd
from dual
--会合并相同的记录
union
select 333 as abc,
444 as bcd
from dual
--不会合并相同的记录
union all
select 333 as abc,
444 as bcd
from dual