select * from testa select * from testb
select * from testa
where not exists
(select * from testb) 结果为空,为什么,该怎么取出差异行 existsoracle
select * from testa
where not exists
(select * from testb) 结果为空,为什么,该怎么取出差异行 existsoracle
选择差异行:
select * from testa a
where not exists
(select * from testb b where a.H0=b.H0)
where not exists
(select * from testb b where a.H0=b.H0 and a.h1=b.h1 and a.h2=b.h2)
select * from testa
minus
select * from testb