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

    Question Unanswered: Does Postgresql 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 PostGreSQL 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
    yes, i think it does

    have you checked the manual?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Sure, it does !

    exactly the way you want it

    SELECT * FROM Mytable Limit 100
    SELECT * FROM Mytable Limit 10,50

    Have fun !
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

  4. #4
    Join Date
    Mar 2004
    Posts
    110
    SELECT fields FROM Table LIMIT 500

    should work.

    Check offset as well for some interesting posibilities.

Posting Permissions

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