Top 50 Records for each category

M

mikesj

I am trying to create a single query where I can show the top 50
records of each category. For instance I have 3 columns in my table

Name | State | Salary

I want to show the top 50 salaries in PA, NJ, DE, MD so a total of 200
should be on my list. I can only get it to show me the top 50 based on
all states, not broken down by state.

Thanks
 
Top