Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Red face Unanswered: TOP not working!

    does mysql support top in select ?
    like
    select top 2 * from table_name
    the above query works fine in ms sql but not in mysql
    any help would be appreciated.
    Regards,
    harshal.

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

    Re: TOP not working!

    Originally posted by harshal_in
    does mysql support top in select ?
    like
    select top 2 * from table_name
    the above query works fine in ms sql but not in mysql
    any help would be appreciated.
    Regards,
    harshal.
    TOP is a microsoft specific keyword, instead in mysql you can use limit

    select * from table_name limit 0,2
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: TOP not working!

    Originally posted by omiossec
    TOP is a microsoft specific keyword, instead in mysql you can use limit

    select * from table_name limit 0,2
    yeah .I got it already thanks.
    Regards,
    harshal.

Posting Permissions

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