Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP !!! SQL GURUS !!!! How do I do this ???
select <VALUE> from <VALUE_TABLE> minus select distinct <COLUMN> from
<TABLE>;
(you need to do the select to get the bigger set first, then remove the
unwanted subset)
Enjoy!
Sol
Jens U. Veigel <jens_at_deutschware.com> wrote in article
<33413a5a.611467603_at_news.aud.alcatel.com>...
> Hey Pro's
>
> Got a problem.
>
> I'm trying to slelect a column which has numbers in it lets say 1
> through 5, and compare it to a list of known values.
> Lets say 1 through10.
> I would like it to come back with all the matching numbers that are
> not in the column such as 6,7,8,9,10.
>
Received on Tue Apr 01 1997 - 00:00:00 CST