表A{1,2,3,4,5,}
表B{4,5,6,7,8,}
select * from A minus select * from B;
结果:1,2,3。
select * from B minus select * from A;
结果为:6,7,8。
select * from A unionselect * from B;
结果为:1,2,3,4,5,6,7,8。
select * from A minus (select * from A minus select * from B);
结果为:4,5。