MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


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


Sorry, you can't reply to this topic. It has been closed.

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.