Posted By: sanchezgmc06 — 10 Mar 2022 at 12:31pm
Hello
Is there a way to select 20 random records from a table?
Using SQL querey
Edited by sanchezgmc06 - 10 Mar 2022 at 12:32pm
Posted By: kevlray — 14 Mar 2022 at 4:18am
I have seen code where 'random' records could be pulled from the data. But it has been a long time and I would have to do some research (on the internet) to see if I could find the code again. Also I am not sure if is truly random or just sampling the data.
Posted By: lockwelle — 14 Mar 2022 at 5:38am
You can use Rand()...You should seed it with a value that changes every record. You will need to manipulate a little.
I cannot seem to post a snippet, you will have to Google it.
