MySQL Forums
Forum List  »  Newbie

Re: Average of best three scores
Posted by: Peter Brawley
Date: September 05, 2017 08:54AM

For ways of doing top N per group, see that topic at https://www.artfulsoftware.com/queries.php

Once you have your top 3's, averaging them is just a simple aggregating outer query.

Options: ReplyQuote


Subject
Written By
Posted
September 05, 2017 07:25AM
Re: Average of best three scores
September 05, 2017 08:54AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.