Subject | RE: [firebird-support] Select last n rows |
---|---|
Author | Tim Gahnström |
Post date | 2005-04-21T19:14:52Z |
> 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