Select 1 rec in 15 rec randomly.

B

Bob

Hello all!
I have a table that has 35,000 records.
How can I select on each 15 records, one random record?

At the end I will have a table that will have about 2,300
records selected randomly, one in each 15.

Thank you.
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top