【IT168技术文档】

　　以下介绍的这个语句只适用于双方记录一样的情况，至于双方互不存在的记录是比较好处理的

　　删除n1,n2中若干条记录

delete from n1 where orderID in ('10728','10730')
delete from n2 where orderID in ('11000','11001')

　　双方都有该记录却不完全相同

select * from n1 where orderid in
(
select OrderID from (select * from n1
union
select * from n2) a group by OrderID having count(*) > 1
)
union
--n2中存在但在n1中不存的在10728,10730
select * from n1 where OrderID not in (select OrderID from n2)
union
--n1中存在但在n2中不存的在11000,11001
select * from n2 where OrderID not in (select OrderID from n1)