Re: Checking for Sequential Numbers

From: Bernd Renzing <chakotay_at_voyager.prima.de>
Date: 10 Jan 2000 12:40:43 GMT
Message-ID: <slrn87jkqa.7ck.chakotay@voyager.prima.de>

On Thu, 06 Jan 2000 20:40:44 +0200 Martin Haltmayer wrote in Message <<3874E1AC.48370E61_at_0800-einwahl.de>>:
>select --+ all_rows

        ^^^ What´s this ? 


>        a.id + 1


>from


>        id_tbl a, id_tbl b

>where a.id + 1 = b.id (+)
>and b.id is null
>order by a.id

Bye, Bernd.
--
Live is for living and living is free, isn't it ? Received on Mon Jan 10 2000 - 06:40:43 CST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US