> 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.
Alan