Monday, February 6, 2012

order by RAND()

mysql allows to perform an "order by rand()" any idea of how this can be useful?
Pubblicato da a

1 comment:

  1. Claudio CorsiFebruary 11, 2012 at 6:44 PM

    Data sampling with equal probability on each element of a finite set.

    Reservoire Sampling is another interesting algo about this topic but in case of a stream of elements.

    Here a good analysis:

    http://gregable.com/2007/10/reservoir-sampling.html

    ReplyDelete

Subscribe to: Post Comments (Atom)