Re: sql question

"Alan" <alan_at_erols.com> wrote in message news:2rr0loF1bkavhU1_at_uni-berlin.de...
>
> "Oxnard" <shankeyp_at_no-spam.comcast.net> wrote in message
> news:hYqdnTbMX6C52sXcRVn-jQ_at_comcast.com...
> > I'm trying to generate an SQL that will return the lowest usable value
> which
> > is higher than zero. Here is the situatuion:
> >
> > DB versio 9.2.0.5.
> >
> > create table mynum(
> > num number constraint mynum_pk primary key,
> > );
> >
> > insert into mynum(num) values (1);
> > insert into mynum(num) values (2);
> > insert into mynum(num) values (4);
> > insert into mynum(num) values (5);
> > insert into mynum(num) values (6);
> >
> > In this case I am looking for a 3 to be returned. I know I can do it
with
> > PL/SQL but I would like to use a single SQL statement.
> >
>
> Why?
>
>

It seems to be the way the application is written, and no, I did not write the application. Received on Mon Sep 27 2004 - 12:38:31 CDT