本文翻译自:Best way to select random rows PostgreSQL
I want a random selection of rows in PostgreSQL, I tried this: 我想在PostgreSQL中随机选择一行,我试过这个:
select * from table where random() < 0.01;
But some other recommend this: 但其他一些人推荐这个:
select * from table order by random() limit 1000;
I have a very large table with 500 Million rows, I want it to be fast. 我有一个非常大的桌子,有5亿行,我希望它快。
Which approach is better? 哪种方法更好? What are the differences? 有什么区别? What is the best way to select random rows? 选择随机行的最佳方法是什么?
#1楼
参考:https://stackoom.com/question/AoGO/选择随机行PostgreSQL的最佳方法
#2楼
postgresql order by random(), select rows in random order: postgresql order by random(),按随机顺序选择行:
select your_columns from your_table ORDER BY random()
postgresql order by random() with a distinct: postgresql以random()顺序排列:
select * from
(select distinct your_columns from your_table) table_alias
ORDER BY random()