Hi,

I need to produce a query where I should only extract the top 10 records according to the rank within the table and for a determined period.

example:
Table contains 500 records for 2 months worth of data (lets say Dec 12 and Jan 13)
Query to show Location and Sales
Query results to give ONLY the TOP10 according to the sales and for the respective month.

Any help is very much appreciated.

Thanks,