Re: SELECT TOP 3 scores in each class with JOIN
Ok, do you see what I need now?
top 3 in each class
removing Best of awards
removing unclassed and disqualified and unscored
sorted first by class
then higher score first
----------
WHERE
HWData.class <> '' //entry must be classed to get scored
HWData.score > 0 //must be scored to get ranked in top 3
HWData.dsqreason = '' //has not been disqualified for any reason
Awards.DSQ <> 1 //if BEST OF award they don't get top 3 trophy
ORDER BY HWData.class,
HWData.score DESC
Subject
Written By
Posted
Re: SELECT TOP 3 scores in each class with JOIN
October 03, 2016 09:15AM
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.