关于union 和 union all 理解

select 1 as one,3 as two from dual
union all

select 1 as two,3 as one from dual

output:

one  two

 1       3

 1       3

union all 不会过滤重复数据,而且字段也是按顺序一一对应生成(貌似和字段名无关,这点union也是一样)

select 1 as one,3 as two from dual
union all
select 1 as two,3 as one from dual

union

select 2 as one,3 as two from dual

output:

one  two

 1       3

 2       3

union 会过滤查询数据的重复结果,字段也是按顺序一一对应生成