Sometimes we do want some randomness in our queries.
To generate a random float number between 0 and 1 we can use the
We could easily modify this function to generate an integer random number within a range (for example, between 21 and 89):
SELECT ROUND(RANDOM() * (89 - 21) + 21)
As you can see the formula to generate an integer number from a range is
RANDOM() * (range_top - range_bottom) + range_bottom.
RANDOM() function could be used to categorize our users for an email AB-test: