mysql - MS Access Stratified Random Sampling -


i trying radomly select given number of rows person submitted request type. example lets there 2 people , people , 3 request types: summary

name:    number of requests:         request type: mary          15                     vaction mary          3                      transfer john          4                      transfer john          3                      pay raise 

i have generated several other queries find number of records randomly sample. have table of detailed information, , table has summary similar 1 above has field "number sample" (e.g. mary vacation 5,m john pay raise 2). have field on main detailed table random numbers. how can sort name, request type, , random number. need pull number of records sorted list match "number sample" field, giving me random sample. did lot of searching cannot find answer. tried using select top not let me feed number of rows in field (even if not sure how able select different number within each subgroup). ideas?

i hope making sense.


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -