Re: Trying to write a tricky query

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Tue, 28 Jun 2005 22:13:53 +0000 (UTC)
Message-ID: <d9si31$5tj$3@klatschtante.init7.net>

On 2005-06-28, laredotornado_at_zipmail.com <laredotornado_at_zipmail.com> wrote:
> Hello,
> I have a list of values,
>
> ('a', 'b', 'c', 'd')
>
> and I am trying to find out which of those values is NOT in the list
> returned from this query
>
> SELECT LETTER FROM LETTER_TABLE
>
> Is there a way I can write a query to extract this information? To
> complicate things, I'm using Oralce 8 on Solaris.

create table letter_table (
  letter char(1)
);

insert into letter_table values ('a');
insert into letter_table values ('b');
insert into letter_table values ('d');
insert into letter_table values ('e');
insert into letter_table values ('f');


select 'a' from dual union
select 'b' from dual union

select 'c' from dual union
select 'd' from dual
minus
select letter from letter_table;

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Tue Jun 28 2005 - 17:13:53 CDT