Top Function

[Mhebor]

I have a table that include 10 different districts with at least 50
records per district. Is there a way I can select 10 records per
district? In other words a total of 100 records with 10 records from
each district. Thank You.

 

[Allen Browne]

Use a subquery to select the TOP n per group.

Details:
http://allenbrowne.com/subquery-01.html#TopN