I know you said that this was Informix, but I'll post the article below anyway for the benefit of other listers. Oracle Technology Network > Oracle Magazine > September/October 2002 Turning On Pivot Tables By Jonathan Gennick http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html Describes a method for Oracle 9i where you don't have to worry that the table you are using to generate sequential numbers does not have enough rows for your query.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Kirtikumar Deshpande > > 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 &). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).