with重用子查询:
with a as (select * from b where xxx)select * from a where xxx;
层次查询:
select * from a where 1=1 start with id = root connect by prior parent = id
合并查询:
union 去掉重复记录;union all 包含重复记录;
intersect 两个查询交集;
minus 两个查询差集,A minus B表示A里存在,B里不存在。