Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Italy
    Posts
    5

    Unanswered: fetch desired rows

    hello,
    I've a large table containing forum's posts.
    It would be very nice using a query to fetch desired number of rows..(from n to k) is there sql syntax to do so?
    Many thanks.
    Paolo

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    Code:
    LIMIT n,x
    where x is k-n. x gives the total number of records fetched, n gives you the first record to start from.

  3. #3
    Join Date
    Mar 2004
    Location
    Italy
    Posts
    5

    ok!

    thanks, It runs well :-)
    Paolo

Posting Permissions

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