Subject Re: [firebird-support] Select last n rows
Author guru
Problem solved, thanks Tim.
I had no idea about using expressions with "skip"...

Tim Gahnström wrote:

> > That why can't use "select first n ..... order by entry_date desc".
>
> It sounds strange what you just sayd but if it is true couldn't you
> somehow do an ugly workaround ike you first do a count and then
>
> "select skip (numberOfElements-100 ) ..."
>
> Or if that is illegal in FB do
>
> "select first 100 skip (numberOfElements-100) ..."
>
> Tim




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 0516-6, 20.04.2005
Tested on: 21.04.2005 22:41:31
avast! - copyright (c) 1988-2005 ALWIL Software.
http://www.avast.com