Generate a random number
To generate a pseudorandom floating point number between 0 and 1, use the RAND() function
Suppose you have the following query
SELECT i, RAND() FROM t;
This will return something like this
iRAND()10.619143887068220.9384516830914230.83482678498591
Random Number in a r...