Re: Finding out last 10 records

[Alexandre Gorbatchev]

Santosh,   There is no "last" and "first" records in relational databases in terms of location. All records are equal and may be stored physically anywhere. I guess that may be possible (parsing ROWID and using information about extent location) to sort records by extent, block and number of record inside block, but that's not a trivial task. If you need to select last 10 inserted records, make a trigger with filling a timestamp into a column and select with sort by this column using rownum in where condition.   Alexandre ----- Original Message ----- From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 14, 2002 11:48 AM Subject: Finding out last 10 records Hello all     Could any one of you guide me on how to select last 10 records from a table. and also finding out first 10 records.. Thanks and regards, Santosh