I have a table

Job# Location Equipment
1111 LA Oven
1112 LA Fridge
1113 NY Oven
113 NY Fridge
etc
.......................

What i am trying to do is a count of jobs grouped by the equipment and then location and only then I only want the top10 for each location by equipment. In other words I am after the top 10 jobs by equipment for each location.

Now I have many pieces of equipment at each location.

I was hoping for something simple as I am actuatlly trying to do this in a rediculous GUI reporting tool that does not let me enter sql manually rather using silly basic sql function i can select by clicking on a button



thanks