Re: SQL Query Question
From: Philip Lijnzaad <lijnzaad_at_ebi.ac.uk>
Date: 11 May 2001 17:07:39 +0100
Message-ID: <u71ypvg984.fsf_at_sol6.ebi.ac.uk>
Date: 11 May 2001 17:07:39 +0100
Message-ID: <u71ypvg984.fsf_at_sol6.ebi.ac.uk>
> On Fri, 11 May 2001 11:24:09 GMT, "Charcoal" <who_at_cares.com> wrote:
>> Assume I have a table which is just a list of numbers (only 1 column). I >> want to perform a query which shows every number under 100 which is NOT in >> the table. How do I do this?
> An interesting question, ... offhand, I would not think this is
> possible without creating a full enumeration in another table, as
> others have said.
yes, I agree, but full enumeration is really what you *don't* want, because chances are that there are thousands of missing numbers. Instead, it's more useful to know what the brackets on the gaps are. This is more compact and gives more insight.
Philip
-- If you have a procedure with 10 parameters, you probably missed some. (Kraulis) ----------------------------------------------------------------------------- Philip Lijnzaad, lijnzaad_at_ebi.ac.uk \ European Bioinformatics Institute,rm A2-08 +44 (0)1223 49 4639 / Wellcome Trust Genome Campus, Hinxton +44 (0)1223 49 4468 (fax) \ Cambridgeshire CB10 1SD, GREAT BRITAIN PGP fingerprint: E1 03 BF 80 94 61 B6 FC 50 3D 1F 64 40 75 FB 53Received on Fri May 11 2001 - 18:07:39 CEST