Whats the best query/solution for this problem
From: Paul <pmartin_at_mitsa.ch>
Date: 1 Nov 2001 05:31:03 -0800
Message-ID: <e582662.0111010531.5756cb16_at_posting.google.com>
Date: 1 Nov 2001 05:31:03 -0800
Message-ID: <e582662.0111010531.5756cb16_at_posting.google.com>
Hello
NR
In a table we have a column (Nr) which contains numbers with holes in the
sequence.
What I need to do is to find the next lowest number to be used.
ie:
--
1
2
5
6
next number = 3 then 4 then 7.
I thought about using rownum to find the holes ie: rownum <> Nr what I am not
sure how rownum works - does it number its rows after an order by of before an
order by ?
Any thoughts / ideas will be greatly appreciated
Sincerely
Paul
Received on Thu Nov 01 2001 - 14:31:03 CET