select * from (
select 1 as id from dual union
select 2 as id from dual union
select 3 as id from dual union
select 4 as id from dual union
select 1 as id from dual
) t
union会合并重复数据
select * from (
select 1 as id from dual union
select 2 as id from dual union
select 3 as id from dual union
select 4 as id from dual union
select 1 as id from dual
) t
union会合并重复数据