RAND function can be used to produce random numbers between 0 and 1.
SQL RAND() Syntax
SELECT RAND()
SQL RAND() Example
Type or Copy the SQL into the Text Editor, click the "View Result" button, to see the result.
RAND function produces random values which are different every time we use it.
SELECT RAND(), RAND(), RAND();
RAND function produces random values which is constant when seeded with a value.
SELECT RAND(1), RAND(1), RAND(1);
SQL in Text Editor: