Is there a way to improve the speed of this query?

SELECT *
FROM tablename ;
WHERE RECNO() >= lnrecno ;
INTO CURSOR mycursor

I am trying to select the last X number of records from a table, but as the table grows, this SELECT statement slows down. Is there a way of improving the speed or another way to select just the last X number of records from a table?

Thanks

Jerryt