Posted by Rodrigo De Le�n on 10/06/07 17:34

On Oct 4, 2:17 pm, Zamdrist <zamdr...@gmail.com> wrote:
> In this case it would be: 4.

SELECT MIN(t2.x +1)
FROM t FULL JOIN t t2 ON t.x = t2.x +1
WHERE t.x IS NULL;

• Next in forum: Full Text Index
• Prev in forum: Re: migrating MSSQL databases to MySQL
• Thread view: Re: Retrieve next lowest number in mixed set

[Reply to this message]