Subject Re: [firebird-support] Select with FB
Author Milan Babuskov
slim wrote:
> Can any one tell me what the sintax is for select last 100. I know that
> Slect First 100 * from works ok but can not find and details for select Last

AFAIK, you have two solutions for this:

1. select count(*) and calculate which are the last 100 records
2. change the order by (asc to desc) and keep FIRST 100 in query


Milan Babuskov