Top N Rows

[mozart]

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

[DaPi]

Search this forum or AskTom and will find things like:
http://asktom.oracle.com/pls/ask/f?p=4950:8:14152877593574113520::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1212501913138,