For a MYsql query to randomly uniformly sample 10 rows ,Is this uniform random sampling or it emits output only till the LIMIT is completed. Are you sure all rows are first assigned the random number and then ordered:
SELECT column FROM table
ORDER BY RAND()
LIMIT 10
None of the answers in this mention about uniform random sampling
How to do uniform random sampling?
Aucun commentaire:
Enregistrer un commentaire