You can use "limit 5". ----- Original Message ----- From: "Markus Siagian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 23, 2001 16:25 Subject: _ > 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?? > > > > > __________________________________________________ > Do You Yahoo!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/ > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
