用这种方法
如果两张表相同则结果为空,反之有记录
1 如果两张表中没有重复数据
(select * from a
minus
select * from b
)
union all
(select * from b
minus
select * from a
)
2 如果两张表中含有重复的数据
(
select a.* ,count(*) from a group by a.*
minus
select b.*,count(*) from b group by b.*
)
union all
(
select b.*,count(*) from b group by b.*
minus
select a.* ,count(*) from a group by a.*
)
PS:此处的a.*,b.*代表a表和b表的所有字段,语法上是错误的。