Subject | Re: [firebird-support] Selecting the Last n rows ... |
---|---|
Author | Helen Borrie |
Post date | 2004-01-19T10:07:16Z |
At 01:44 AM 19/01/2004 -0800, you wrote:
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
>Is there any option such as SELECT LAST n SKIP 0 FROMThere is no such command.
><tablename> ? This
>particular line doesn't seem to work.
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