读书人

not exists无效?该怎么解决

发布时间: 2013-08-01 15:23:18 作者: rapoo

not exists无效?
select * from testa
not exists无效?该怎么解决
select * from testb
not exists无效?该怎么解决

select * from testa
where not exists
(select * from testb)

结果为空,为什么,该怎么取出差异行

exists oracle
[解决办法]
这个结果必须为空啊....
选择差异行:
select * from testa a
where not exists
(select * from testb b where a.H0=b.H0)
[解决办法]
最简单的方法就是利用minus
select * from testa
minus
select * from testb

读书人网 >oracle

热点推荐