In SQL, the RAND() function allows you to select a random number with a comma, between 0 and 1. The result of this function will be different each time the function is executed in an SQL query.
The syntax for using the RAND() function is as follows:
SELECTRAND();
Here is a list of possible results of this function:
0.8702846307962059
0.0648367116831585
0.7657416637667843
It is possible to perform mathematical operations with the result of this function. For example, to get a random number between 0 and 100, just multiply the result of RAND() by 100, as in the example below:
SELECT RAND() * 100;
You can round this number with the ROUND();
SELECT ROUND(RAND()*100)