When answering this question, I wrote up this SQL answer, which works fine from my machine.

However, on SE data, it always picks the same winner. Is it possible that SE Data fixes rand() to a specific number? If so, why is that?

1 Answer 1


The data explorer caches results; if you run identical queries, it will only call the database once, and deliver the cached result on subsequent queries.

  • That explains it, perhaps SE Data could explain a warning for queries using rand()
    – Andomar
    Jul 28, 2011 at 9:34

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .