RE: Diffrence between rows in sql

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Alan Shore
>
> This problem intrigued me and BOTH are nice suggestions, but ( and I could
> be wrong on this) if the ones that are missing are
> 15
> 16
> 17
>
> 21
>
> this sql would NOT report 16 & 17 as missing

Thus the second SQL.  A more polished version (and then I have work to do):

SELECT A.SEQ+1 HOLESTART, MIN(C.SEQ)-1 HOLEEND
 FROM MYSEQ A, MYSEQ C
  WHERE NOT EXISTS
    (SELECT 1 FROM MYSEQ B WHERE B.SEQ = (A.SEQ+1))
  AND C.SEQ > A.SEQ GROUP BY A.SEQ
  ORDER BY HOLESTART

Joe