Dumb Oracle Question
From: Mtek <mtek_at_mtekusa.com>
Date: Wed, 4 Jun 2008 15:16:54 -0700 (PDT)
Message-ID: <f3d5d36b-1d82-465f-bd97-0ccd650f6133@b1g2000hsg.googlegroups.com>
Date: Wed, 4 Jun 2008 15:16:54 -0700 (PDT)
Message-ID: <f3d5d36b-1d82-465f-bd97-0ccd650f6133@b1g2000hsg.googlegroups.com>
Hi,
Aren't these statements supposed to be equal??
select cust_no from customer where z_rank_d = 1
minus
select cust_no from customer_rank1;
select cust_no from customer where z_rank_d = 1
and not exists
(select cust_no from customer_rank1);
What am I missing? The first returns 27 rows, the second, nothing.......
John Received on Wed Jun 04 2008 - 17:16:54 CDT