> On 18 Mar 2019, at 16:15, Dan Kennedy wrote:
>
>
> In SQLite, a correlated sub-query on the RHS of an IN(...) operator may be
> rerun every time the IN(...) test is required. And if that sub-query contains
> "random()" it might return a different result every time.
>
> Your words suggest
On 18/3/62 17:36, Kevin Martin wrote:
Hi,
I am trying to use a correlated subquery with an 'order by random() limit 2' to
pick upto two random rows for each value in the outer query. I am not sure if I
am doing this correctly, but the number of rows I am getting seems to vary
randomly which
2 matches
Mail list logo
