Re: SQL help needed

You would require something like this:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:504432994857

HTH
GovindanK

> Hello Listers,
>
> I need some SQL help.
> Not sure if this is possible in plain SQL or not, but here it is:
> I have a table with two columns:
> EMPNBR LINENBR
> ------ -------
> 100 1
> 200 4
> 300 8
> 400 9
> 500 14
>
> How would I find out the missing linenbrs (2,3,5,6,7) if I was given
> minlinenbr as 1 and
> maxlinenbr as 10 that would be passed as variables (using &).
>
> Thanks.
>
> - Kirti
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: cornichepark_at_cwazy.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).