Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Portugal
    Posts
    1

    Red face Unanswered: Problems with TOP function....

    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
    Last edited by MIGVIPER; 03-13-03 at 10:44.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    You could write your own stored procedure that selects only the first or the last x rows.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •