Query needed

[ashish_gr3at]

I have columns named as
State | Savings

There are 52 States and I want top 10 savings in each of the state as saving is repeated in each state

Like
CA $123
CA $143
CA $345
AK $123
AK $564
CA $145

and so on ...

My requirement is to make a query to extract top 10 savings from each of state, so the output is like top 10 saving for CA(out of 120 CA records) next top 10 saving for AK (out of 90 Records)

And this is for all US states.

Appreciate your any kind of help.

 

[CT Witter]

Check out the MS KB Article ACC2000: How to Create a "Top N Values Per Group" Query
http://support.microsoft.com/kb/210039


HTH,
CT