Monday, February 6, 2012

order by RAND()

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

1 comment:

  1. 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