Hey, Hopefully this isn't a newbie question. I'm currently using MySQL 3.23.35a and I'm looking how to get an "olympic" style average of values in a table where the top and bottom n scores are dropped from the average calculation. Example: table: opinions columns: id, score values: 1 9 1 9 1 9 1 1 1 10 2 7 2 8 2 7 2 6 2 7 The results would be: 1 9 2 7 Any ideas on how to write a select query to return the desired results? Hopefully there is an easy answer. Thanks in advance for your help. Phade. --------------------------------------------------------------------- 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
