Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Hyderabad
    Posts
    7

    Exclamation Unanswered: First n records from a query

    Hi,

    I want to retrive first n records of a query first and next n records later. Can I do that? And how?


    Regards
    Vinaya

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: First n records from a query

    Originally posted by Vinayarammohan
    Hi,

    I want to retrive first n records of a query first and next n records later. Can I do that? And how?


    Regards
    Vinaya
    Why not to use LIMIT offset, RowNumber
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Feb 2004
    Location
    Hyderabad
    Posts
    7

    Smile

    Hi,

    Thanks for the help.
    Can you also pls gimme the syntax?

    Thanks in advance
    Vinaya

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by Vinayarammohan
    Hi,

    Thanks for the help.
    Can you also pls gimme the syntax?

    Thanks in advance
    Vinaya
    Read The Friendly Manual: http://www.mysql.com/doc/en/SELECT.html

Posting Permissions

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