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 years
order bysome other columns just change the column name.
group byis unnecessary as you don’t need the
Edit: Found on this post that you should add parenthesis
If you have better answer, please add a comment about this, thank you!