diff options
Diffstat (limited to 'src/datastore/selectrandom.sql')
-rw-r--r-- | src/datastore/selectrandom.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/src/datastore/selectrandom.sql b/src/datastore/selectrandom.sql new file mode 100644 index 000000000..82830a13a --- /dev/null +++ b/src/datastore/selectrandom.sql | |||
@@ -0,0 +1,9 @@ | |||
1 | select * | ||
2 | from (select random() as v from (values(1))) t1, | ||
3 | (select max(repl) as m from data) t2, | ||
4 | (select * from data | ||
5 | where repl=t2.m and | ||
6 | rnd>=t.v | ||
7 | order by rnd | ||
8 | limit 1) | ||
9 | |||