Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL question

Re: SQL question

From: Ramin Goettlich <goettlich_at_shs.de>
Date: Sat, 26 Dec 1998 13:08:38 +0100
Message-ID: <3684d1cd.0@news.munich.netsurf.de>


Impossible with one select.

>Hallo,
>
>if I have the following table:
>
>Nr Text
>-- ----
>1 'Text1'
>2 'Text2'
>4 'Text3'
>
>I want to search for the first 'free' Nr, which should be 3 in this
>case. How to do it with one select?
>Thank you in advance!
>
>Burkhard Schultheis
>Tele Data
Received on Sat Dec 26 1998 - 06:08:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US