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