Re: sql question

On Mon, 27 Sep 2004 12:04:06 -0500, Oxnard wrote:

> 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.
>
> Thank you for your time.

Read up on analytic functions in the Data Warehouse doc. Specifically, look at lead and lag functions. Received on Mon Sep 27 2004 - 12:37:05 CDT