Top 5 based on 2 categories

Trying to figure out how to do a top 5 but I need top 5 by category.  

So as an example if I have 4 categories, I want the top 5 product in each category.

New user so sorry so appreciate any help.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Top 5 <column name> for each <column name>.

    You can use 'for each' keyword.

    Like 1
Like1 Follow
  • Status Answered
  • 1 Likes
  • 3 mths agoLast active
  • 1Replies
  • 14Views
  • 2 Following