Question:
I’m trying to find the best 5 students from 2016 and 2017. My query right now looks like this:picture of my output
What is a possible way to have the top 5 from 2016 and 2017 in the same column?
Answer:
This should return you the top 5 for both yearsorder by
some other columns just change the column name.Also the
group by
is unnecessary as you don’t need the max()
aggregate function.Edit: Found on this post that you should add parenthesis
If you have better answer, please add a comment about this, thank you!