blob: 82830a13a89247e45ba2334dc0047e14ee5ebd7e (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
select *
from (select random() as v from (values(1))) t1,
(select max(repl) as m from data) t2,
(select * from data
where repl=t2.m and
rnd>=t.v
order by rnd
limit 1)
|