Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    77

    Unanswered: Problem about Select Top

    Hi I use MySql 5 , I tried to run this query

    SELECT TOP 3 * from cat order by CatID asc
    But I got this error
    Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3 * from category order by CategoryID asc' at line 1
    Anyone has any comment !!

  2. #2
    Join Date
    Aug 2004
    Posts
    77
    Ok it works now.......

Posting Permissions

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