On Fri, 23 Mar 2001, Markus Siagian wrote: > Hi, > I'm still a newbie in mysql and also sql statements. > I > was wondering if some one can help me with this > problem. > > I'm trying to select 5 of the highest values from a > table. But i can't seem to find any help from the > manual and also some other books. In the manual, > there > is only a function to find the highest(max) value. > > Do i need to make a new function?? Lookup ORDER BY and LIMIT clauses in the manual. It would be: select * from my_table order by a_column limit 0,5; regards, thalis --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
