SQL中union all、union、minus、intersect的用法

select * from 表1 where 条件1... UNION ALL select * from 表1 where 条件1...
select * from 表1 where 条件1... UNION select * from 表1 where 条件1...
select * from 表1 where 条件1... MINUS select * from 表1 where 条件1...
select * from 表1 where 条件1... INTERSECT select * from 表1 where 条件1...