sql question

How can we made a sql request on a huge table that will get out the last lines without using the rowid column? ex.: let's say that count(*) return 10000 on this table. If we want to get the last fifty lines, for now we are doing: select col1, col2 from table where rowid > 9950 Any help will be appreciate! ============================================================================= --- Herve Delmas ---- delmas@ireq.hydro.qc.ca ============================================================================= -- ============================================================================= --- Herve Delmas ---- delmas@ireq.hydro.qc.ca =============================================================================