Example
Return a random decimal number (no seed value – so it returns a completely random number >= 0 and <1):
SELECT RAND();
Definition and Usage
The RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
Syntax
RAND(seed)