Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> need crash course in EXISTS
two tables, identical layouts, let's call them A and B, each with a
number and a char
for simplicity.
This query yields 81 rows.
select a from A
MINUS
select a from B
This query returns 458 rows -
select * from A
where
EXISTS
(select a from A
MINUS
select a from B)
What gives?
![]() |
![]() |