Please Share Feedback


Questions, comments, suggestions? Let us know what you think on our Forum.

To contact us privately, please use our contact form.

Author: Elyse, PMP, CPHIMS
July 23, 2004


Top 5 doesn't work too well in selecting SQL statements in MySQL. However an operator that limits the size of the result set is LIMIT.

For example,

SELECT * FROM tbl LIMIT 10;

Subscribe and Share!

Did you enjoy this article? Your feedback is very important! I'd like to invite you to keep up to date with the latest posts from Anticlue. We offer several venues. If you have some questions, help can be found here.
 

1 Comments to “Getting the Top 10 MySQL Query Results.”

dude thanks, ihad thatsame problem with mysql and this is the first page google showed me, and it was very very helpful thanks again


« The 100 most wired JCAHO on Bar-Coding. »

Please share your thoughts and suggestions