Getting last rows

Hello,

how can i get the last rows from a select which have a rownum restriction :

Select ID_COL from MYTABLE where mycondition and rownum<100 order by ID_COL desc;

With this request i don't have the last entries. I am working with Oracle 7.3.4 and Oracle 8.1.6

Best regards Received on Mon Mar 12 2001 - 09:41:45 CST