Re: Query to find first missing integer in a field

From: Thomas Kellerer <>
Date: Tue, 07 Apr 2009 22:02:58 +0200
Message-ID: <>

dean wrote on 07.04.2009 21:51:
> Does anyone know a good way to find the first free integer number that
> does not exist in a table in a specified column? I can think of a
> couple of tedious ways of doing this but they are hardly elegant.
> Assume there could be any integer present up to 2 billion.

Why would you want to do that? Received on Tue Apr 07 2009 - 15:02:58 CDT

Original text of this message