© Ugur Akinci
RAND() function is used to generate a RANDOM number between 0 and 1. The function takes no argument.
GENERAL SYTNTAX is:
Here are some examples:
If you multiply the result with 100, RAND() return a random number between 0 and 100:
If you’d like to return only INTEGER results, use this function together with INT() function, as in: