Re: SQL question

From: Shujda <shujda_at_prodigy.net>
Date: Tue, 29 Dec 1998 22:37:45 -0500
Message-ID: <3689A008.9DA6C6BA@prodigy.net>

Great solution, great idea. But, it doesn't return 1 when we have values like 2,3,5,6...
This is complete script:
SELECT decode(MIN ( a.col1)

                            ,1,MIN ( a.col1 + 1 )

   ,1)
FROM junk a
WHERE NOT EXISTS (

        SELECT  1
        FROM    junk b
        WHERE   b.col1 = ( a.col1 + 1) )

Terje Tysse wrote:

> What about :
>
> SELECT MIN ( a.nr + 1 )
> FROM data a
> WHERE NOT EXISTS (
> SELECT 1
> FROM data b
> WHERE b.nr = ( a.nr + 1) ) ;
Received on Tue Dec 29 1998 - 21:37:45 CST