Subject | Re: [firebird-support] Select last n rows |
---|---|
Author | guru |
Post date | 2005-04-21T19:41:26Z |
Problem solved, thanks Tim.
I had no idea about using expressions with "skip"...
Tim Gahnström wrote:
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
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