Subject RE: [firebird-support] Re: whats the opposite of first?
Author Alan McDonald
> here is what i have in a similar situation
> and it puts out the last 10 records in the desc order
> SELECT glno,tc,orgcur,alias FROM GL3 WHERE glno >=
> (GEN_ID(GLNO_GEN,0)-10)
> glno is an integer generated via GLNO_GEN genarator and an
> on insert trigger, works nicely.
> Nx

not sure I like this.
delete a few records from the last ten in the table and see what result set
you get.