Re: How to do this trick ?

From: <rtproffitt_at_my-deja.com>
Date: Fri, 15 Oct 1999 23:38:26 GMT
Message-ID: <7u8dth$c2e$1_at_nnrp1.deja.com>

Thanks Turkbear,

In fact, the results would have been wrong if there were duplicate MyNums...
I have revised the query to use group by instead...

select rownum, FirstNum, PrevNum, Firstnum-PrevNum Diff From
(select Rownum FirstRow, MyNum FirstNum
  from (select mynum

        from bob
        group by mynum, rowid) FirstTbl) a,

(Select Rownum+1 PrevRow, MyNum PrevNum
  from (select mynum

        from bob
        group by mynum,rowid) PrevTbl) b

Where FirstRow=PrevRow

Robert Proffitt

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 16 1999 - 01:38:26 CEST