Re: SQL Query Question
From: Mladen <mladen_delic_at_yahoo.com>
Date: Fri, 11 May 2001 14:46:27 +0200
Message-ID: <9dgmkq$1aj$1_at_ss204.hinet.hr>
Date: Fri, 11 May 2001 14:46:27 +0200
Message-ID: <9dgmkq$1aj$1_at_ss204.hinet.hr>
You have to have another table (ex. Table1) with at least 99 records. Then
make a temporary table Table2(CREATE TABLE TABLE2 (allnumber NUMBER) and
populate it with this command: INSERT INTO Table2 (SELECT rownum FROM Table1
WHERE rownum <100).
Finally, issue this command:
SELECT allnumber FROM Table2 WHERE allnumber NOT IN (SELECT * FROM MyTable).
Hope that thi will work.
Mladen.
Received on Fri May 11 2001 - 14:46:27 CEST