在外层套1个查询，加上distinct关键字就能够去重了select distinct * from (select * from a union all select * from b)t 查看更多答案>>
