Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how do I select the last 5 rows in informix

Status
Not open for further replies.
cymerman

cymerman

MIS
Jan 9, 2007
16
0
0
US
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 ?
 
Sort by date Sort by votes
Use " select first 5 * from <table name> order by <colname> desc
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kray4660
  • Locked
  • Question
Informix 3.500.00.14008 64-bit ODBC driver download
Replies
0
Views
53
kray4660
kray4660
daYorkie
  • Locked
  • Question
How many UNIONs can i use in a single query?
Replies
2
Views
66
daYorkie
daYorkie
Liliana Solis
  • Locked
  • Question
Correr script desde informix 4gl
Replies
0
Views
52
Liliana Solis
Liliana Solis
arunkumar.ceg
  • Locked
  • Question
How to call informix 4gl from script
Replies
0
Views
62
arunkumar.ceg
arunkumar.ceg
jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
63
jamescpp
jamescpp

Part and Inventory Search

Sponsor

Back
Top