--查询相同数据
select [字段名]或[*]
from [表名称1]
intersect
select [字段名]或[*]
from [表名称2]
--查询不同数据
select [字段名]或[*]
from [表名称1]
except
select [字段名2]或[*]
from [表名称]
--查询相同数据
select [字段名]或[*]
from [表名称1]
intersect
select [字段名]或[*]
from [表名称2]
--查询不同数据
select [字段名]或[*]
from [表名称1]
except
select [字段名2]或[*]
from [表名称]
转载于:https://www.cnblogs.com/stray-dog/p/4290406.html