Simple question: Does MySQL support top(n) function?
Posted by: Wesley Henrique
Date: February 12, 2005 05:21AM

I'm using this simple query: "select top 5 * from table order by field ascw"

But it's returning an error:

#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5 * from table order by table asc' at line 1


Does MySQL support top(n) function?

Options: ReplyQuote


Subject
Written By
Posted
Simple question: Does MySQL support top(n) function?
February 12, 2005 05:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.