Hello,
I have a little problem here....
I want to select the last 5 rows of a table to publish in a intranet, and since the informix version that I am using doesn't support the TOP function (I don't know if any version of informix does it), I would like to ask if anyone as some kind of solution, cuz I am running out of ideas...
By the way, the function's 'Last' and 'First' are not supported ether.

Anyone with similar problem outhere can help??

Thank's

You could write your own stored procedure that selects only the first or the last x rows.