Select X # of records for each Name in the column

  • Thread starter Thread starter Sheryl Scanlon
  • Start date Start date
S

Sheryl Scanlon

I have a table with a name column in it (among others).
There are multiple records for each name and they all have
different numbers of records.

I need to pull a random sample of 10 records for each name
in the table and put them into a spreadsheet. How do I go
about this query/queries to accomplish this?

When I tried to do it, I could come up with a random
sampling of the whole table, but I couldn't divide it up
to give me 10 of each name.

Thanks for any help you can provide.
 
Back
Top