随笔分类 -  oracle

摘要：intersect运算返回查询结果中相同的部分select job from accountintersectselect job from researchintersectselect job from sales;minus运算返回在第一个查询结果中与第二个查询结果不相同的那部分行记录。select job from accountminusselect job from sales; 阅读全文