Re: SELECT TOP 3 scores in each class with JOIN
I guess I just don't understand...
I still need to have the rest of the data.
your query now excludes all the rest of the data.
I only wanted to exclude Awards.DSQ = 1
HOW DO I GET ROWS WHERE Awards.DSQ does not apply?
if hwdata.award = '' then there is no join. I need those rows also.
Subject
Written By
Posted
Re: SELECT TOP 3 scores in each class with JOIN
October 03, 2016 05:24PM
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.