Examples of RAND Function :
Example 1 : Use of RAND function in select clause
SELECT RAND()
Output
0.64006458477337
Above example returns different value each time when you execute above query because each time sql takes different input value for RAND function.
Example 2 : Use of RAND function in select clause
Output
Above example always returns same result for specified input value for RAND function.