Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> need crash course in EXISTS

need crash course in EXISTS

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 26 May 1999 17:49:41 -0400
Message-ID: <374C6C75.1995B3F7@bigfoot.com>


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?

Received on Wed May 26 1999 - 16:49:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US