This function returns an evenly distributed random number between 0 and 1.
RAND()
This function does not accept arguments.
This function returns a new random number.
To generate a random real number between x and y, with y greater than x, use the following expression:
RAND()*(y-x)+x
To generate a random integer between x and y, with y greater than x, use the following expression:
INT((y-x+1)*RAND()+x)
For more information, refer to Volatile Functions.
Does not accept data. Returns numeric data.
RAND()
RAND()*100
INT(RAND()*100)