| Subject | RE: [firebird-support] how to select last N records, firebird sql |
|---|---|
| Author | Alan McDonald |
| Post date | 2006-11-08T11:20:02Z |
> -----Original Message-----you have to think about the order you want them in - i.e. last of what?
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of Aydemir Memisoglu
> Sent: Wednesday, 8 November 2006 9:28 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] how to select last N records, firebird sql
>
>
> Hi all,
> How can I select the last N records from a firebird database?
>
and then use
SELECT FIRST 5 FIELD1 FROM TABLENAME ORDER BY MYPREFERREDINDEX DESC
Alan