sql - Best way to select random rows PostgreSQL - Stack Overflow

PHOTO EMBED

Fri Jul 23 2021 21:12:42 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira #sql

select * from table where random() < 0.01 limit 1000;
content_copyCOPY

https://stackoverflow.com/questions/8674718/best-way-to-select-random-rows-postgresql