retrieving only 10 rows

J

Joao

How can you retrieve the latest 10 records of, for example, 5670 records
within a database?

Where rowcount<10 ?? Oracle isn't it?

Thanks in advance.
 
R

Ron2006

If you have an autonumber record ID then sort descending by that
number. - Assuming that that number is defined in the typical
autonumber style.

Ron
 
Top