SELECT ... ORDER BY score LIMIT 10 PB
----- ----- Original Message ----- From: "Kevin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 1:11 PM Subject: Query - Top Ten > Hello, > > I have a table with the following structure and values: > > CustomerID Score > > 4 8 > 2 6 > 3 2 > 3 8 > 4 7 > 2 7 > > I would like to query for the top ten customer averages. Is this possible in > a single query? > > The result will be something like: > > CustomerID Average Score > 4 7.5 > 2 6.5 > 3 5 > > TIA. > > Kevin > > > > > > > --------------------------------------------------------------------- > 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