I have a grouped, summed query, grouped on PSeason, Name(of client), summed on totalamount, ordered by PSeason, totalamount (desc).
What I need to do is only return the top 5 clients in each season, by highest totalamount. This query currently returns all clients.
I am stumped as to how to do it. I assume I will put this query as a subquery into a another query but beyond that, I am stuck.
Can you help me?
Many thanks in advance,