Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    France
    Posts
    10

    Question Unanswered: Does Informix support LIMIT

    Hi,

    I'm creating a software, and I have a dilemn... To check it I use MySQL, but I want my software to use a lot of kind of différent DB (oracle, DB2, informix, etc...)

    But I have to know :

    Does Informix support something like that (and if not how to do it) :

    SELECT fields FROM Table LIMIT 0,500

    ????

    thank you very much for a quick answer, because All development depend of the answer !!!

    thank you,
    bye.
    Last edited by ffert; 06-24-04 at 19:45.
    DataBase, Delphi, php, Yes, I like....

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    HI,
    Please test:
    SELECT FIRST 500
    fields
    FROM Table

    Gustavo.

Posting Permissions

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