sql quiz

Hi,

SQL> describe t1;

 Name                            Null?    Type
 ------------------------------- -------- ----
 C1                                       NUMBER

SQL> select c1 from t1;

        C1

         1
         4
         7
         8
         9
        10

Question:

I need to retrieve the missing numbers (2,3,5,6) from t1. How can I do this in ONE sql statement? I know that this can be done in PL/SQL.

Any ideas?
Thanks
Naren Received on Tue Jan 06 1998 - 00:00:00 CST