SQL: Select a random sample
To pick a random subsample of 1,000 rows from a table:
select t.*
from table t
order by rand()
limit 1000
;
SQL: Select a random sample
To pick a random subsample of 1,000 rows from a table:
select t.*
from table t
order by rand()
limit 1000
;
Leave a comment