I would ask WHY you need to do this...
"Lars Reineke" <reineke_at_kreiskrankenhaus-hameln.de> wrote in message
news:ak26or$1ev86v$1_at_ID-1759.news.dfncis.de...
> Hi!
>
> Given a table A with a column NUMBER, which stores numerical values, let's
> say in a range from 1 to 9999, how do I retrieve the values that are in
that
> range but not stored into that table?
>
> NUMBER
> --------------
> 1
> 2
> 3
> 4
> 5
> 7
> 8
> 10
>
> I would like to get the not assigned 6, the 9 and so on.
>
> Many thanks in advance.
>
> Greetings
> Lars
>
>
Received on Thu Aug 22 2002 - 15:02:20 CDT
