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