Subject Re: whats the opposite of first?
Author nxciro
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 >=

glno is an integer generated via GLNO_GEN genarator and an
on insert trigger, works nicely.