sql question

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. Received on Mon Sep 27 2004 - 12:04:06 CDT