Subject Re: [firebird-support] Selecting the Last n rows ...
Author Helen Borrie
At 01:44 AM 19/01/2004 -0800, you wrote:

>Is there any option such as SELECT LAST n SKIP 0 FROM
><tablename> ? This
>particular line doesn't seem to work.

There is no such command.
Instead, do
SELECT FIRST n <fields you want>
FROM <tablename>
ORDER BY <a suitable indexed columnset> DESC

Of course, you will get them "last first"...
/hb