Re: Finding out last 10 records

[Yechiel Adar]

Check the doc: SQL reference, basic elements of Oracle SQL pseudocolumns. The explanation on rownum gives you examples for your problem.   Yechiel Adar Mehish ----- 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