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

    Unanswered: Does DB2 support LIMIT

    Hi,

    I'm creating a software, and I have a dilemn... To check it I use MySQL, but I want to be use with DB2, Oracle and a lot of kind of différent DB.

    But I have to know :

    Does DB2 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.
    DataBase, Delphi, php, Yes, I like....

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, DB2 does not support LIMIT

    look in the manual for FETCH FIRST
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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