how do I select the last 5 rows in informix

[cymerman]

How do I select the last 5 rows of a table ?
I have to use "order by" I guess.

If this is not possible. How do I select just 5 rows (any rows) of that table ?

 

[shhankar]

Use " select first 5 * from <table name> order by <colname> desc